this query is acting wierd..

[insrtsnhere13]

[code]$query = "UPDATE users SET username=\"$username\" and user_password=\"$password\" and email=\"$email\" and user_level=\"$userlevel\" WHERE id=\"$id\"";

$result = mysql_query($query) or die ("Error in query: $query. ".mysql_error());[/code]

all of the variables are pulled from a form and pulled properly.. I have echoed all of them during testing..

the form basically reads the database, and fills the form with what the user provided upon registration..

then, when update is pressed, its reads the form, assigns variables to each thing, and then updates the database regardless of a change..

so far, when ive tried changing the any of the entries, instead of updating them, all it does is set the username value "0" and nothing else.

[ChambeRFienD]

Try this:

$query = "UPDATE users SET username=\"$username\", user_password=\"$password\", email=\"$email\", user_level=\"$userlevel\" WHERE id=\"$id\"";

[insrtsnhere13]

thanks that did it