[Resolved] bad UPDATE syntax?

[jasonmills58]

Is there some thing wrong with this? I'm getting a MySQL syntax error, and I'm hoping I won't have to do SET username = '$username', password = '$password' etc etc....

	$query = "UPDATE clients SET ( username, password, clientname, email, phone, fax, 
				address1, address2, city, state, zip, accesscal, accessnote, accessrec )
			= VALUES( '$username', '$password', '$clientname', '$email', '$phone', '$fax', 
				'$address1', '$address2', '$city', '$state', '$zip', 
				'$accesscal', '$accessnote', '$accessrec' )
			WHERE clientname='$clientname'";

Am I just being lazy, or is there a way to make this work?

[TTT]

syntax is wrong

UPDATE yourtable SET x=1 WHERE z=2

...

INSERT INTO table (a,b) VALUES (1,2)

[jasonmills58]

bummer, so I have to do all those value pairs? I was hoping I could just cut and paste that syntax from my INSERT statement... Will my WHERE hold up as is, implementing the variable like that?

thanks for the info!

[TTT]

yes. ...set x=1,y=2
where sentence is ok

[jasonmills58]

thanks a bunch!