Re: [PHP-WIN] MySQL query error

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

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