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.