MySQL - UPDATE & INSERT
| From: | Phil Schwarzmann | Date: | Fri, 05 Apr 2002 18:58:29 +0000 |
| Subject: | MySQL - UPDATE & INSERT | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-91779@lists.php.net to get a copy of this message | ||
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!!!!!!!!!!!!!