MYSQL UPDATE query syntax

[selina]

I'm trying to update a database using UPDATE query but i don't seem to have the correct syntax. But I can't figure out the correct one, either.
I'm using MySQL 4.0.
Please help!!

code:
$update_reply_sql="UPDATE tbl_guests SET guest_rsvp=('".$_POST['reply']."') WHERE guest_id='".$_POST['showid']."'";
$update_reply_res=mysql_query($update_reply_sql, $mysql) or die(mysql_error($mysql));

 

[CrazeD]

Try this:

$update_reply_sql="UPDATE tbl_guests SET guest_rsvp='{$_POST['reply']}' WHERE guest_id='{$_POST['showid']}'";