Update with more than one variable?

[tmp_]

I have a forum software I've almost completed, but I need for the admin panel to update a user's entry all at once, I tried something like this:

 

$query = "UPDATE users SET id='$id', username='$nam', password='$pass', email='$email',  registerdate='$reg', lastlogin='$log', title='$title', status='$stat' WHERE usernamename = '$user'";

mysql_query($query) or die(mysql_error());

 

But no matter what I put the table isn't updated. I tried SET id='$id' AND username = '$nam' with all AND's instead of commas, but they don't update the query still, how do I update more than one column at the same time?

 

I can't find anything online that does this

[trq]

What error do you get?

 

password is a function in mysql so you'll need to surround it in backticks.

 

, `password`='$pass', 

[tmp_]

Alright, thanks! Seemed I also made the form to edit the variables POST to the wrong place, it works fine now.