Thank You, " . $row['firstname'] . "
";
$email = $row['email'];
} else {
die("No match for user id " . $uid);
}
}
if (isset($_GET['ml'])) {
$ml_id = $_GET['ml'];
$sql = "SELECT * FROM ml_lists WHERE ml_id = '" . $ml_id . "'";
$result = mysql_query($sql)
or die('Invalid query: ' . mysql_error());
if (mysql_num_rows($result)) {
$row = mysql_fetch_array($result);
$msg .= "Thank you for subscribing to the " .
$row['listname'] . " mailing list.
";
} else {
die ("Could not find Mailing List $ml_id");
}
} else {
die ("Mailing List id missing.");
}
if (!isset($_GET['t'])) {
die("Missing Type");
}
switch ($_GET['t']) {
case 'c':
$msg .= "A confirmation request has been sent " .
"to $email.
";
break;
case 's':
$msg .= "A subscription notification has been " .
"sent to you at $email.
";
}
$msg .= "" .
"Return to Mailing List Signup page";
echo $msg;
?>