'AND' not working

[ueon]

$jobs = mysql_query("SELECT * FROM work WHERE email='$request' AND primary='1'"); // This doesn't work

$jobs = mysql_query("SELECT * FROM work WHERE email='$request'"); // This works

 

I know for a fact that there's a column in work called "primary"

 

but it's giving me this error: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource

[PFMaBiSmAd]

primary is a reserved mysql keyword. You either need to rename your column to something else or you must enclose it in back-ticks `` every time you use it in a query.

[ueon]

thanks works perfectly