public static function fetchFromDbForEmail($email)
{
NewsletterSubscription::$staticErrors = array();
$sql = "SELECT * FROM bsi_newsletter_subscriptions WHERE email = '" . mysql_escape_string(strtolower(trim($email))) . "'";
$query = mysql_query($sql);
if (!$query) {
die("Error: " . mysql_error());
}
if ($row = mysql_fetch_assoc($query)) {
$newsletterSubscription = NewsletterSubscription::fetchFromParameters($row);
return $newsletterSubscription;
} else {
array_push(NewsletterSubscription::$staticErrors, "No newsletter subscription with email: {$email} exists");
return null;
}
}
