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!!!!!!!!!!!!!
- Re: [PHP] MySQL - UPDATE & INSERT Phil Schwarzmann
- Re: [PHP] MySQL - UPDATE & INSERT Julie Meloni
- Re: [PHP] MySQL - UPDATE & INSERT Erik Price
- [PHP] Re: MySQL - UPDATE & INSERT Chris Adams
- RE: [PHP] MySQL - UPDATE & INSERT Rick Emery