Hello, i'm pretty new into SQL Server, i've used MySQL time ago and maybe some things might be different or idk...
Btw, i'm making a register page for a server and i'm experiencing a problem with a query...
I'm using php oop and pdo:
I tried a select query on Navicat too and it's extremely weird to me...
When i put:
It says that the column name "test" is not valid, it should search through the column "Name" and look for "test", what's wrong in it?
I hope to get helped as soon as possible, thank you in advance!
EDIT:
Figured out by myself, in the query i cannot use RowCount with SELECT statement, and about navicat i was typing "test" instead of 'test'
Btw, i'm making a register page for a server and i'm experiencing a problem with a query...
I'm using php oop and pdo:
Code:
$stmt = $conn->prepare("SELECT count(*) FROM dbo.Account WHERE Name = :name");
$stmt->bindParam(":name", $username);
$stmt->execute();
if($stmt->rowCount()) $error = "This username already exists";
When i put:
Code:
SELECT * FROM dbo.Account WHERE Name="test"
I hope to get helped as soon as possible, thank you in advance!
EDIT:
Figured out by myself, in the query i cannot use RowCount with SELECT statement, and about navicat i was typing "test" instead of 'test'