Re: [PHP] MySQL - UPDATE & INSERT

On Friday, April 5, 2002, at 01:58 PM, Phil Schwarzmann wrote: > Is this query legal? > > $query = "UPDATE table SET (var1, var2, var3) VALUES ($var1, $var2, > $var3) WHERE username='$username'"; No. The SET modifier (or whatever that is) can only be used to create column name/value rela

RE: [PHP] MySQL - UPDATE & INSERT

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) VALUE

Re: [PHP] MySQL - UPDATE & INSERT

The UPDATE syntax in the manual: http://www.mysql.com/doc/U/P/UPDATE.html UPDATE [LOW_PRIORITY] [IGNORE] tbl_name SET col_name1=expr1, [col_name2=expr2, ...] [WHERE where_definition] [LIMIT #] Yes, it is different than the INSERT syntax. PS> ...but only there are like 150 diffe