CREATE TABLE `users` ( ) ENGINE = MYISAM;
INSERT INTO users VALUES ('user', 'you@example.com', 'abc123');

<?php

//CONNECTS TO YOUR DATABASE (MODIFY TO YOUR OWN SETTINGS)
$c = mysql_connect("server", "username", "password");
$db = mysql_select_db("your_database", $c);

$table = 'users';

?>

function fp(){ } <table>
<tr><td align="right">Email: </td><td align="left"><input id="email"> Type an email that you regularly check for the demo but it must match the one in the database. Change <b>"you@example.com"</b> in your database.</td></tr>
<tr><td align="right"></td><td align="left"><input onClick="fp()" type="button" value="Get Password"></td></tr>
<tr><td align="right"></td><td align="left"><span id="message"></span></td></tr>
</table>

<?php

$email = $_POST["email"];
$email_test = eregi("^([A-Za-z0-9_-]+)(\.[A-Za-z0-9_-]+)*@([A-Za-z0-9_-]\.)*([A-Za-z0-9_-]+)\.[A-Za-z]{2,}$", $email);

if($email_test){
    include("settings.php"); //FILE WITH THE IMPORTANT MySQL INFORMATION
    
    $server_un = 'you'; //USERNAME OF YOUR WEBSITE EMAIL ADDRESS (CHANGE TO YOUR OWN) Ex: admin
    $domain = $_SERVER["HTTP_HOST"]; //DOMAIN NAME WITH EXTENSION; Ex: (wcetdesigns.com)
    $server_email = $server_un.'@'.$domain; //YOUR WEBSITE'S EMAIL ADDRESS
    
    $q = mysql_query("SELECT * FROM $table WHERE email='".$email."'");
    $n = mysql_num_rows($q);
    $r = mysql_fetch_assoc($q);

    if($n&&$r["email"]){
        $to = $email;
        $subject = "Forgot Password";
        $headers = "From: Your Site <".$server_email.">\r\n";
        $headers .= "Content-type: text/html\r\n";
        $message = "You have requested that you forgot your password.<br>
                    Password: <b>".$r["password"]."<b>";
        
        mail($to, $subject, $message, $headers);
    
        echo 'Password sent to <b>'.$email.'</b>';
    }
} else {
    echo 'Invalid Email';
}

?>