";
$answer = trim($_POST['answer']);
$checkusername = $_POST['checkusername'];
if ($answer != "")
{
$sql = mysql_query("select answer from Quiz_users where answer = '$answer' and username = '$checkusername'");
if (mysql_num_rows($sql) > 0 )
{
$sql = "select email from Quiz_users where username = '$checkusername'";
$result = mysql_query($sql);
$row = mysql_fetch_row($result);
$email = $row[0];
$random_password = makeRandomPassword();
$message = "We have received a request to change your password at Quiddle.
You new username is still your old username and your new password is $random_password
If you have not attempted to retrieve or change your password, please contact us
Customer Service";
mail($email,"Your password at Quiddle has been reset",$message,"Content-Type:text/html; charset=iso-8859-1");
$db_password = md5($random_password);
$sql = mysql_query("update Quiz_users set password = '$db_password' where username = '$checkusername'");
echo "Thank you!
Please check your email for your new password!";
echo "
To return to the home page click
here";
}
}
$subscribe = $_POST['subscribe'];
if ($subscribe != "")
{
$username = trim($_POST['username']);
$sql = mysql_query("select question, username from Quiz_users where username = '$username'");
echo "Hello $username
";
$row = mysql_fetch_array($sql);
$question = "$row[0]";
$checkusername = "$row[1]";
if ($question == "city") echo "Please enter your city of birth below
";
if ($question == "pet") echo "Please enter your favorite pet below
";
if ($question == "mom") echo 'Please enter your Mother\'s maiden name
below
';
?>
![\"Quiddle,](\"images/quiddle_masthead.jpg\" "\\"quiddle\\"")