> 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]
