UPDATE Query

Any thoughts on why this won't work?

$update = mysql_query("UPDATE Emails WHERE ID='$emailID' SET
clicked = '$clickedstatus' ");

when I echo $insert it insists on returning False. I've verified the following:

1) I am successfully connected to a databse containing a table called Emails.

2) In this table there are two columns, ID and clicked.

3) The value of $emailID successfully matches a value in the ID column of the Emails table.

4) The value of $clickedstatus is defined as the string "clicked" and successfully echos as such.

So....in light of those, any ideas? I'm stumped. Thanks.

Hi,

I think you must sligntly modify the SQL

$update = mysql_query("UPDATE Emails WHERE ID='$emailID' SET
clicked = '$clickedstatus' ");

So it looks like this

$update = mysql_query("UPDATE Emails SET
clicked = '$clickedstatus' WHERE ID='$emailID' ");

If you really think there is some error in your SQL syntax then try this
if($update==false) {
echo mysql_error();
}

Cheers!

Thanks! It works now!