Re: [PHP-WIN] MySQL query error

2007-07-07 Thread Ben
Not to mention that read would most likely be a tinyint(1), and thus shouldn't be fed a character. Stut wrote: 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

Re: [PHP-WIN] MySQL query error

2007-06-30 Thread Stut
<[EMAIL PROTECTED]> Cc: 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"

Re: [PHP-WIN] MySQL query error

2007-06-30 Thread Stut
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

[PHP-WIN] MySQL query error

2007-06-30 Thread James Blandford
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 ma

[PHP-WIN] MySQL query error

2007-06-30 Thread James Blandford
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 ma