Thank You, " . $row['firstname'] . "
";
$e-mail = $row['e-mail'];
} 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 $e-mail.
";
break;
case 's':
$msg .= "A subscription notification has been " .
"sent to you at $e-mail.
";
}
$msg .= "" .
"Return to Mailing List Signup page";
echo $msg;
?>