I don't see the issue with this syntax; help?

[monkeytooth]

mysql_query("SELECT TitleSafe FROM thebook WHERE key='".mysql_real_escape_string($bookKey)."'") or die(mysql_error());

 

Says I have a syntax error near: key='73350' key is a BIGINT don't know if that means anything to this issue, but thats the whole line throwing the error. Any ideas?

[mikesta707]

you shouldn't use single quotes for numeric data types. try removing the single quotes

[PFMaBiSmAd]

Key is a reserved mysql keyword. Change it to something else or enclose it in back-ticks.

[monkeytooth]

Removing the quotes didnt change anything, still get the same error.

 

who ever developed this database used key as someone would use ID, does that still hold the difference as to what you said about key being reserved? id so should I change the name of the whole column to ID or something?

[monkeytooth]

Well decided to change the column name to ID,

alter the line of code as such:

mysql_query("SELECT TitleSafe FROM thebook WHERE ID=".$bookKey."") or die(mysql_error());

 

Unfortunately I still get an error:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

 

I have tried a couple variations of the line as well, with or without quotes, with or without mysql_real_escape_string still the same thing.

[PFMaBiSmAd]

If you form the query in a variable first, so you can echo it to see exactly what it is, you will probably find that $bookKey is empty.

[monkeytooth]

Cutting out the SQL and echoing the $bookkey var, echo's what the bookkey var is.. searching the db manually through phpmyadmin for the number bookkey shows also yelids a result.