> I have a form for a user to request their forgotten username and password
> 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
> 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]

Reply via email to