PHP/MYSQL Trouble Selecting by Primary Key

Question

Hi all, So I have a primary key column called key. I'm trying to select the row with key = 1 via this code:

$query ="SELECT * FROM Bowlers WHERE key = '1'"; 
$result = mysql_query($query) or die(mysql_error());

For some reason, I'm getting this result:

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 'key = '1'' at line 1

The mysql statement works for using other keys, ie WHERE name = 'djs22'.

Any ideas?

Answer 1

key is a reserved word, try putting ticks around it:

$query ="SELECT * FROM `Bowlers` WHERE `key` = '1'"; 
$result = mysql_query($query) or die(mysql_error());

To see all the reserved words, go here and scroll down: http://dev.mysql.com/doc/refman/5.1/en/reserved-words.html

Answer 2

'key' is a reserved keyword, put backtick quotes around it:

"SELECT * FROM Bowlers WHERE `key` = '1'"

Answer 3

Without checking, it's likely that "key" is a reserved word in MySQL. Try wrapping it in backticks

$query ="SELECT * FROM Bowlers WHERE `key` = '1'";  

Answer 4

You should write the column name key in quotes

$query ="SELECT * FROM Bowlers WHERE `key` = '1'";

Otherwise it is a keyword