SQL Error WHERE AND Clause problem with PHP

Hi all,

Its been ages since i have asked for programming help i have not done much in ages and trying to get back in to it anyway im wanting to work on my current projects however i run into a problem however not working the way i want and the error is an old ugly error ive attempted to look on the internet to try and solve this looking at tutorial but nothing i can find.

error is this “Error: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 ‘read=0’ at line 1)”;

What does that mean does this Query point out anything obivious to you?

Query = “SELECT * FROM pms WHERE reciever=‘demo’ AND read=‘0’”;

Not sure what the problem is here but i cant find anything wrong with it seems fine unless ive made a stupid error?

Can anyone help me and help me refresh my memory?


READ is a reserved word: http://dev.mysql.com/doc/refman/5.6/en/reserved-words.html

Change the column name, or put it in backticks.