On Wed, Dec 19, 2001 at 12:24:02PM -0700, Zach Curtis wrote:
> 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. It's a one way encryption. It even says so in the MySQL Reference manual entry for PASSWORD(). -- 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]
