Database query failed, help

Having a few problems but not sure why I get the following result

database query failed:Unknown column ‘Reading’ in ‘where clause’

from this php code

$result = mysql_query(“SELECT * FROM worktopm_products.locations WHERE location = Reading”, $connection);
die(“database query failed:”. mysql_error());

The table exists, and “Reading” is in one of the rows in the location field

the reason you got the “Unknown column” message is because syntactically it looks like it’s a column –

WHERE location = Reading

if you put it into quotes, then it becomes a string value –

WHERE location = ‘Reading’

doo be doo be doo… :cool:

Check the spelling of Reading, is it meant to be reading?

Isn’t Reading a place in the UK ?