RE: [PHP] order of update??

The order doesn't matter, but perhaps you might want to put single quotes around your $a at the end of your SQL statement. You didn't mention the error that you were getting, but this might help nonetheless :) update tablename set x='$x', y='$y', z='$z' where a='$a'; HTH Sam Masiello Software Quality Assurance Engineer Synacor (716) 853-1362 x289 smasiello@synacor.com -----Original Message----- From: Gerard Samuel [mailto:trini0@optonline.net] Sent: Thursday, August 23, 2001 3:00 PM To: PHP Subject: [PHP] order of update?? My seem stupid to some, but when running update tablename set x='$x', y='$y', z='$z' where a=$a; Does it matter if it the set were in backwards order ie z, y, x ?? Just curious, Im having a problem and I dont know if its because of the order.... Thanks -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net For additional commands, e-mail: php-general-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net