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
[EMAIL PROTECTED]
-----Original Message-----
From: Gerard Samuel [mailto:[EMAIL PROTECTED]]
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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
