what happened when you tried your query? -----Original Message----- From: Phil Schwarzmann [mailto:[EMAIL PROTECTED]] Sent: Friday, April 05, 2002 12:58 PM To: [EMAIL PROTECTED] Subject: [PHP] MySQL - UPDATE & INSERT
Is this query legal....? $query = "UPDATE table SET (var1, var2, var3) VALUES ($var1, $var2, $var3) WHERE username='$username'"; Im wondering cause I have an INSERT query.... $query = "INSERT INTO table (var1, var2, var3) VALUES ($var1, $var2, $var)"; ...but only there are like 150 different variables and it will take me forever to write a query like.... $query = "UPDATED table SET var1='$var1', var2='$var2', var3='$var3' WHERE username='$username'"; THANKS!!!!!!!!!!!!! -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
