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

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