if (!isset($submitok)): ?>
");
?>
Forgot Password?
else: // check for existing user $checkquery = "SELECT COUNT(*) FROM user WHERE handle = '$forgotid' AND status = 'active'"; $checkresult = mysql_query($checkquery); if (mysql_result($checkresult,0,0)!=0) { // get password $sql = "SELECT AES_DECRYPT(password,'aA') AS password, email FROM user WHERE handle = '$forgotid'"; $result = mysql_query($sql); if ($result && mysql_num_rows($result)) {$userinfo = mysql_fetch_assoc($result);} $password = $userinfo['password']; $email = $userinfo['email']; // Email the password to the person. $message = "Just a Reminder, Your password is: $password "; mail($email,"Password Reminder - California Diamond", $message, "From:California DiamondSuccess!
Your password has been emailed to =$email?>.
} else { ?>Unable to Process
Your account has not yet been activated, or the User Name does not exist. Please try again, or call us at 1-866-644-6555 for more information.
} endif; ?>