Mysql update not updating

kayelle

Hi,

Part of my script updates a user table with a randomly generated password.
The variables are correct and the statement works if I run it manually in mysql. Mysql does not generate any errors and when I wrap the printed results with a test to see if the update worked, my results print fine with all of the correct values. I'm also using this same update statement in another script to change a password and it works fine. I don't get it. Tearing my hair out. Here's the relevant code:

(I'm using Pear and the db connection is fine)

// generate random new password, encrypt and insert into table user

$userid = $result['userId'];
$password = mkpasswd();
$new_pw = md5($password);

$update = $db_object->query("UPDATE user SET password= '$new_pw' WHERE userId = '$userid'") or die(mysql_error());

if ($update) {

echo "$new_pw userid:$userid username: $username email: $email pw: $password ";

}

Am I missing something?

Thanks

stolzyboy

are you getting any errors

have you echo'd out your query after you set it to see if the
vars are coming thru correctly

have you tried using the sql statement at a mysql prompt

etc...troubleshoot then tell us the results, easier to help you
that way

kayelle

yeah, I've tried all of those things. That's what's so strange. There are no errors at all and according to my results, everything is working fine, but the db isn't changing at all. I print the statement and it looks fine. I used the orinted statement as my manual query and it worked. I've tried this on my local server and on the host, but get the same results.

Also I'm using the same exact update statement in another script and it works fine.

stolzyboy

instead of doing it this way

$update = $db_object->query("UPDATE user SET password= '$new_pw' WHERE userId = '$userid'") or die(mysql_error());

humor me and try it this way

$query = "UPDATE user SET password= '$new_pw' WHERE userId = '$userid';";
$result = mysql_query($query) or die(mysql_error());

kayelle

:rolleyes: ARG! I figured it out. I was disconnecting from the db after a previous select statement. Using your query led to a "no database selected" error.

Thanks much for getting me there.