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
<[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"
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
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
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