UPDATE problem

[Anon]

Hi all,

I just can't seem to get UPDATE to work when called from the web:

$sql2 = ("UPDATE MemberMsgs SET MsgRead='$msgread' WHERE Mesg_ID='$msgid' AND User_ID='$userid'") || die ("Couldnt update record");

$msgid & $userid come from a web form and are present and valid (tested by doing a select on the table with the same info...the record gets returned). $msgread is hardcoded just above this line.

There is no error and the rescpective record isn't updated! I've even tried setting the files' permissions to 777, still nothing.

Any suggestions??

Thanks,
gary

[Anon]

Shouldn't need to change file permissions. Try your update query with the mysql command line tool, or phpMyAdmin. It should give you a little more helpful error message.

[[deleted]]

Mesg_ID='$msgid'

id's are integers, they are never quoted.

change your 'or die' to

or die(mysql_error())

(preferable take out the or die, and use proper error checking through an IF statement)