RE: [PHP] MySQL - UPDATE & INSERT
| From: | Rick Emery | Date: | Fri, 05 Apr 2002 19:03:27 +0000 |
| Subject: | RE: [PHP] MySQL - UPDATE & INSERT | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-91783@lists.php.net to get a copy of this message | ||
what happened when you tried your query?
-----Original Message-----
From: Phil Schwarzmann [mailto:pschwar@jhmi.edu]
Sent: Friday, April 05, 2002 12:58 PM
To: php-general@lists.php.net
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!!!!!!!!!!!!!