It should be "$id". Note that missing " Prathap ---------- Original Message ----------- From: "Ross" <ross@xxxxxxxxxxxxx> To: php-general@xxxxxxxxxxxxx Sent: Thu, 5 May 2005 12:09:18 +0100 Subject: is this the correct syntax > Am trying to do an update of a record... > > Is this the correct syntax.. > > $query= "UPDATE $table_name SET fname='$fname', sname='$sname' > WHERE id= $id"; > > R. > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php ------- End of Original Message ------- -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php