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]