";
$sEmailAddress = $_POST['EmailAddress'];
$strSQL = "SELECT FullName, EmailAddress, Username, Password FROM tblUsers " .
"WHERE EmailAddress = '" . mysql_real_escape_string($sEmailAddress) . "' " .
"AND Status = 1";
$result = mysql_query($strSQL);
if(mysql_affected_rows() == 1)
{
$db_data = mysql_fetch_row($result);
$sMessage = "Hi " . $db_data[0] . "\n\n" .
"Your username and password for the \"" . $aSettings["CompanyName"] . "\" newsletter system are as follows:-\n\n" .
"Username: " . $db_data[2] . "\n" .
"Password: " . $db_data[3] . "\n\n" .
$aSettings["CompanyName"] . "\n" .
$aSettings["ContactEmail"];
mail($db_data[1], "Password Reminder", $sMessage, "From: " . $sFromAddress . "\n");
$bSent = true;
}
}
?>