Sorry, your new password must be 3 or more letters. Please go back and try again.";
exit();
}
if ($newpass1 != $newpass2)
{
print "Sorry, your new password is not confirmed. Please go back and try again.
";
exit();
}
if (trim($answer) == '')
{
print "Sorry, your must answer your secure question.
";
exit();
}
$query = "SELECT FirstName from SR_instructor WHERE InstructorID = '$id' AND Answer = '$answer'";
$result = mysql_query($query, $connection) or die ("Error in query: $query. " . mysql_error());
// if row exists -> user/pass combination is correct
if (mysql_num_rows($result) == 1)
{
//update password
$query = "update SR_instructor set Password = OLD_PASSWORD('$newpass1') where InstructorID = '$id' and Answer='$answer'";
mysql_query($query, $connection) or die ("Error in query: $query. " . mysql_error());
}
else
{
print "Error: Your answer is incorrect. Please go back to try again or contact LLC. Thank you.
";
exit();
}
print <<
Your password has been changed.
Click here to login.