Database query failed, help

Databases
1

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);
if(!$result){
die(“database query failed:”. mysql_error());
}

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

2

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:

3

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

4

Isn’t Reading a place in the UK ?