[prev in list] [next in list] [prev in thread] [next in thread] 

List:       php-windows
Subject:    Re: [PHP-WIN] MySQL query error
From:       Stut <stuttle () gmail ! com>
Date:       2007-06-30 22:10:09
Message-ID: 4686D4C1.7040901 () gmail ! com
[Download RAW message or body]

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?

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

[prev in list] [next in list] [prev in thread] [next in thread]