PHP/MYSQL Different Trouble Selecting By Primary Key:

Question

Due to some help from a recent post, I'm selecting a row by primary key, as follows:

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

For some reason, the third line of code dies every time, without error. It works fine using other keys, ie WHERE name = 'djs22'.

Any ideas?

Answer 1

You are using single quotes on the field name, you must use backticks.

not ', but `

Answer 2

try

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

or

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

instead of

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

Answer 3

try using this

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

I just replaced ' ' by .