Re: MySQL query error

Please include the list when replying. James Blandford wrote:

It seems i have fixed it >_< thanks for your time thou. It turns out that I couldn't have "read" as a field name due to some random reason. I changed it to "itsread" and it works perfectly :0)

It wasn't a random reason - "read" is on the reserved words list: http://dev.mysql.com/doc/refman/5.0/en/reserved-words.html -Stut -- http://stut.net/ > ----- Original Message ----- From: "Stut" <stuttle@gmail.com> > Newsgroups: php.windows > To: "James Blandford" <icy.moons@gmail.com> > Cc: <php-windows@lists.php.net> > Sent: Saturday, June 30, 2007 10:55 PM > Subject: Re: [PHP-WIN] MySQL query error > > >> James Blandford wrote: >>> 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. >> >> Query looks fine. Are you sure the table and field names are correct?