Syntax

[Kudose]

$query = "UPDATE users WHERE username='$username' AND password='$password' SET (username, password, fname, lname, age, email, city, state, type)
VALUES ('$username', '$password', '$fname', '$lname', '$age', '$email', '$city', '$state', '$type')" or die(mysql_error());

I get this:

You have an error in your SQL syntax near 'WHERE username='XXXX' AND password='XXXXXX' SET (username, password, fname, lname' at line 1

Any ideas? I may be using UPDATE wrong, but I am not sure on how to fix this error.

Thanks

[daphreeek]

instead of using SET (.....) VALUES (.....) use SET username='$username', password='$password'........

[xblue]

and put the where clause at the end.

syntax description:
http://www.mysql.com/doc/en/UPDATE.html

[Kudose]

$query = "UPDATE users WHERE username='$username' AND password='$password' SET username='$username', password='$password', fname='$fname', lname='$lname', age='$age', email='$email', city='$city', state='$state', type='$type')" or die(mysql_error());
mysql_query($query) or die(mysql_error());

Error was becuase of a ) in the query, that didnt need to be there. Sorry for your troubles. But that link proved helpful. Thank you.