0

Hello, i'm very new here in these forums.
I'm making a webpage for registration for my online game's server.
My problem is in the registering part, i've got the query to register the new user on the database, but first i need to check if the name of the account in the field isn't used yet. My code to do so is:

$query = mssql_query("SELECT * FROM memb_info WHERE memb___id = ".$_POST['cuenta']."");
 // memb_info is the table, memb___id is the accountname


if ($query) {print "does exist"; }
// just was a test

the problem is, if i type an existing account name, look which is the error:

Warning: mssql_query() [function.mssql-query]: message: The name of the column 'armakapo' is not valid. (severity 16) in C:\xampp\htdocs\caca.php on line 15

I guess it's searching for COLUMNS in the memb_info table, instead of ROWS.
because if i put in the account field "memb___id" (a name of a column), it says "does exist"
so, can you help me to make it search for a row instead of a column name? thanks you very much!

1
Contributor
1
Reply
2
Views
9 Years
Discussion Span
Last Post by armakapo
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.