UPDATE help

[Rayn]

I am using this code.

$conn = mysql_pconnect('localhost', 'pass', 'name') or die('Could not connect to db');
mysql_select_db('db', $conn) or die ('Could not select db');

mysql_query("UPDATE news SET title='News',content='stuff' WHERE newsid=1");

Now I can use mysql_query to get info from the db and delete it.. but I cannot seem to be able to update a table.. can any of you tell me whats wrong with this?

Thanks
- Me

[cgraz]

I'd use mysql_error() and also add single quotes around the 1.

$query = mysql_query("UPDATE news SET title='News',content='stuff' WHERE newsid='1'") or die(mysql_error());

Cgraz

[Rayn]

thanks bro