Help With UPDATE

[monkeypaw201]

Here is the code:

 

<?php

$con = mysql_connect("localhost","user","pass");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }mysql_select_db("database", $con);

mysql_query("UPDATE private_messages SET read = 'Yes'
WHERE id = '$_GET[id]'");mysql_close($con);
?>

 

Its not working... no errors, the page loads fine, it just doesnt update

[revraz]

Put the query in a string, echo the query to make sure it is reading your id, and use mysql_error() after your query to see if there are any errors.

[monkeypaw201]

Put the query in a string, echo the query to make sure it is reading your id, and use mysql_error() after your query to see if there are any errors.

 

Query in string outputs: UPDATE private_messages SET read = 'Yes'

WHERE id = '1'

 

mysql_error after query outputs:

 

(nothing)

 

Soooo Lost...

[monkeypaw201]

can anyone help?

[revraz]

Remove the single quotes around 1 and see if it works.

[monkeypaw201]

did help... i'm pretty much clueless on whats wrong..

[monkeypaw201]

UPDATE:: Typo on post above, DIDN'T HELP...

 

Anyone? ???

[Coreye]

Try:

<?php

$con = mysql_connect("localhost","user","pass");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }mysql_select_db("database", $con);

mysql_query("UPDATE `private_messages` SET `read`='Yes' WHERE `id`='" . $_GET['id'] . "')or die(mysql_error()); mysql_close($con);
?>