> I have a form for a user to request their forgotten username and password by > entering their email address. I then process this and use mail() to send > them their username and password. However, the password is stored in an > encrypted PASSWORD('password') field in the MySQL table. How can I retrieve > the decrypted password in a SELECT statement?
You can't. This is what I do: 1) Use password('$password') to store my passwords. 2) Since this is a one-way algoritme I replace the password with some random letters (and encrypt it!) 3) Then I email the new password to the user 4) And.. force the user to change the password at the first login. Best Regards Fredrik A. Takle Bergen, Norway -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]