Forgot Password?

[d99kg]

I am establishing a mail ordering website and I want a Forgot Password link, whereby the user has to enter there user name and their password is sent to them via their e-mail. The username, password and their e-mail address are stored in a MySQL database.

I am fairly new to PHP so any help ideas would be greatly appreciated!

Cheers

[matbennett]

Which bit is it that you are having a problem with?

If you are storing passwords in an encrypted form then you may not be able to do exactly what you say. If you have encrypted using MD5 then you will have to generate a new password rather than sending the old one as the encryption is one way.

[epimeth]

not the complete code, but the important bit....

$sql = "SELECT * FROM usertable WHERE usernamefield LIKE $user";
$result = sql_query($sql);

if (sql_num_rows($result) == 1)
{
 $row = sql_fetch_assoc($result);
 $pword = $row['passwordfield'];
 $email = $row['emailfield'];

 $mailsubject = "Your password";
 $mailbody = "Your Password is $pword";

 mail($email, $mailsubject, $mailbody);
}

hope this helps...

[d99kg]

The passwords are not stored in encrypted form!

Any ideas

Cheers

[d99kg]

Thanks very much I'll see what i can do!!!