ERROR - Empty email address.";
else
{
$sql = sprintf("UPDATE cas_members SET Email=NULL, Newsletter='N' WHERE Email='%s'", trim($_POST["Email"]));
$db->query($sql);
if (mysql_affected_rows() > 0)
$msg = "SUCCESS - You have been unsubscribed from our email newsletter.";
else
$msg = "ERROR - Invalid email address.";
}
}
if (isset($_POST["UnsubSMS"]))
{
if (strlen(trim($_POST["Mobile"])) == 0)
$msg = "ERROR - Empty mobile number.";
else
{
$sql = sprintf("UPDATE cas_members SET Mobile=NULL, SMSAlerts='N' WHERE Mobile='%s'", trim($_POST["Mobile"]));
$db->query($sql);
if (mysql_affected_rows() > 0)
$msg = "SUCCESS - You have been unsubscribed from our SMS Alerts.";
else
$msg = "ERROR - Invalid mobile number.";
}
}
// delete any empty rows
$sql = "DELETE FROM cas_members WHERE Email IS NULL AND Mobile IS NULL AND Newsletter='N' AND SmsAlerts='N'";
$db->query($sql);
?>
mPageSubNavArr as $subpage) {
if($_GET['pageId'] == $subpage['ID'])
printf("