MySQL UPDATE error

[aeboi80]

For the life of me I cannot figure out what I have mistyped.  I am trying to do a simple UPDATE query.

 

Here is the error which I am getting:

 

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(`first_name`, `last_name`, `email`, `address1`, `address2`, `city`, `stat' at line 1

 

 

Here is the PHP and SQL statement:

 

$firstName = ucwords(protect($_POST['first_name']));
$lastName = ucwords(protect($_POST['last_name']));
$email = protect($_POST['email']);
$address1 = ucwords(protect($_POST['address1']));
$address2 = protect($_POST['address2']);
$city = protect($_POST['city']);
$state = protect($_POST['state']);
$zip = protect($_POST['zip']);
$country = protect($_POST['country']);
$phone = protect($_POST['phone']);

$res2 = mysql_query("UPDATE ".DB_TABLE_PREFIX . "members SET(`first_name`, `last_name`, `email`, `address1`, `address2`,
				`city`, `state`, `zip`, `country`, `phone`)
				VALUES('".$firstName."','".$lastName."','".$email."','".$address1."','".$address2."','".$city."','".$state."',
				'".$zip."','".$country."','".$phone."') WHERE username = '".$_SESSION['loggedin_username']."'") or die(mysql_error());

 

[marcus]

That's the wrong syntax for an update query.

 

$sql = "UPDATE `table` SET `field`='".$field1."' , `field2`='".$field2."' WHERE `this`='".$that."'";

[Pikachu2000]

You're using INSERT syntax with an UPDATE query . . .

 

UPDATE `table` SET `field1` = 'value1', `field12`= 'value2', `field3` = 'value3' etc.

[aeboi80]

Thank you guys !