Calling data, changing it then updating the change in the table.

[bofett]

There must be a simple way to handle this.  I updated my php site to include md5 for passwords.  Now I need to go through and change all of the existing passwords to md5 so the current users won't be impacted.

 

I was thinking of running something like one time:

                $qrl = mysql_query("SELECT * FROM users");
                while( $row2 = mysql_fetch_object($qrl) ){
                  $oldpassword = $row2->password;
                  $newpassword = md5($oldpassword);
                  mysql_query("update users SET password=$newpassword");
                  }

 

Thanks for your help.

[trq]

A simple..

 

UPDATE users SET `password` = MD5(`password`);

 

Will do.

[bofett]

Thank you, thank you, thank you!

 

A simple..

 

UPDATE users SET `password` = MD5(`password`);

 

Will do.