SQL UPDATE error

[elmas156]

I'm getting the following error and I've looked everywhere but I can't figure out what's wrong... any suggestions?

 

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 = 'yes' WHERE messid = '1'' at line 1

 

Here's the code:

mysql_query("UPDATE messages SET read = '$yes' WHERE messid = '$messid'") or die (mysql_error());

[PFMaBiSmAd]

http://dev.mysql.com/doc/refman/5.1/en/reserved-words.html

 

Read, as you might imagine, and the point where the error occurred,  is a reserved keyword.

 

Either rename your column to something else or enclose read in back-ticks `` every time you use it in a query.

[elmas156]

Thanks!