not updating mysql db

[qo2o]

if($submit)
{
$name = $_COOKIE["name"];
$db = mysql_connect("secret", "secret", "secret");
mysql_select_db("secret",$db);
$sql = "UPDATE users SET (email, age, sex, loc, aim, msn, icq, yim, descrip) VALUES (\"$nmail\", \"$nage\", \"$nsex\", \"$nloc\", \"$naim\", \"$nmsn\", \"$nicq\", \"$nyim\", \"$ndescrip\") WHERE name = \"$name\"";
$result = mysql_query($sql, $db);
}

trying to get it to change db entries after a form is submitted with the variables listed in there, i don't know what im doing wrong.

thanks in advance for any suggestions

[laserlight]

do a little debugging, like use

$db = mysql_connect("secret", "secret", "secret")
OR die("Could not connect");

and

$result = mysql_query($sql, $db)
OR die(mysql_error());

you might also have to use
if (isset($_POST['submit']))
instead.

[qo2o]

"You have an error in your SQL syntax near '(email, age, sex, loc, aim, msn, icq, yim, descrip) VALUES ('[e-mail]', '2' at line 1"

is the error i recieve when i did:

mysql_query($sql, $db) or die(mysql_error());

[laserlight]

I generally prefer this syntax:

$sql = "UPDATE users SET
	email = '$nmail',
	age = '$nage',
	sex = '$nsex',
	loc = '$nloc',
	aim = '$naim',
	msn = '$nmsn',
	icq = '$nicq',
	yim = '$nyim',
	descrip = '$ndescrip'
	WHERE name = '$name'";
$result = mysql_query($sql, $db)
	OR die(mysql_error());

might work for you.