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?
For example, the following results in retrieving the encrypted password. $result = mysql_query("SELECT userName,password,email FROM members WHERE email='$email'"); if (!$result) echo "<p>Could not execute database query:<br>" . mysql_error() . "</p>"; $row = mysql_fetch_array($result); $userName = "$row[userName]"; $password = "$row[password]"; $email = "$row[email]"; Thank you. Zach Curtis Programmer/Analyst POPULUS -- 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]