Problem selecting from database.

midol

Ok, I'm trying to select a row from my database using a unique "key". The problem is for some reason every time I try I get this response.
"You have an error in your SQL syntax near 'key = '00ddcbf73805288e19044a1efc853ed5'' at line 1"

Here is my statement...
$sql = "SELECT * FROM tablenamehere WHERE key = '$key'";
The field type for key is longtext, I don't know if it matters or not.
"00ddcbf73805288e19044a1efc853ed5" is a sample key that I'm using.
So basically I'm trying to figure out why it won't me select using key as my where. If I switch the where part to another field it works fine, so I know its not my syntax. I've been switching things and trying every possible combination for hours now and can't get it to work so any input is appreciated.
Thanks,
Ryan

hand

Is this really the original select statement? I don't think so.
Please try following:

$sql = "SELECT * FROM tablenamehere WHERE key = '$key'"; 
print "sql:$sql<br>\n";
$result = mysql_query($sql)
   or print "&gt;&gt;&gt; MySQL-Error: ".mysql_errno()." -&gt; ".mysql_error()."<br>\n";

Run again, tell us the result of the print statements and post your original statement including the mysql_query() statement.

Lars_Berg

key is a reserved word in sql. Rename the column with an alter table statement.

hand

... or you can quote the fieldname key with backticks

$sql = "SELECT * FROM tablenamehere WHERE `key` = '$key'";

... but its definitely better to alter the name!

I think midol did not pots the real sql statement, so I asked him to do it.

midol

That was my true sql statement, I just took out the table name. I just renamed key to usercode and everything works fine now. Thanks for the info, I never would have guessed that.