Jump to content

Archived

This topic is now archived and is closed to further replies.

insrtsnhere13

this query is acting wierd..

Recommended Posts

[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.

Share this post


Link to post
Share on other sites
Try this:

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

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.