Computer Forums - View Single Post

selina · 05-09-2007, 02:03 PM

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));

05-09-2007, 02:03 PM	#1 (permalink)
selina True Techie Join Date: Feb 2006 Posts: 228	MYSQL UPDATE query syntax 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));