MySQL query error

Hello,
I am making a private messaging system for my website, and if you click on
the pm, it --should-- set it as "read" rather than "unread". I am using the
query:
UPDATE pms SET read=1 WHERE id='{$assoc['id']}'
but it is giving me 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=1 WHERE
id='4'' at line 1
To me, this query looks perfectly fine, but obviously it isn't. Please can
you tell me how to make it work.
Cheers,
James

--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php