<?php
  require('config.php');
  
  $conn\; =\; mysql\_connect(SQL\_HOST,\; SQL\_USER,\; SQL\_PASS)\; or\; die(\text{'}Could\; not\; connect\; to\; MySQL\; database.\; \text{'}\; .\; mysql\_error());\; mysql\_select\_db(SQL\_DB,$conn);
  
  if (isset($\_GET[\text{'}u\text{'}],$_GET['ml'])) {
    $sql\; =\; "DELETE\; FROM\; ml\_subscriptions\; "\; .\; "WHERE\; user\_id="\; .$_GET['u'] .
           " AND ml_id=" . $\_GET[\text{'}ml\text{'}];$result = mysql_query($sql,$conn);
  } else {
    die("Incorrect parameters passed for deletion");
  }
  
  if ($result)\; \{$msg = "<h2>Removal Successful</h2>";
  } else {
    $msg\; =\; "$<h2>Removal Failed</h2>";
  }
  
  ml_id = $\_GET[\text{'}ml\text{'}];$sql = "SELECT * FROM ml_lists WHERE ml_id = '" . $ml\_id\; .\; "\text{'}";$result = mysql_query($sql)\; or\; die(\text{'}Invalid\; query:\; \text{'}\; .\; mysql\_error());\; if\; (mysql\_num\_rows($result)) {
    $row\; =\; mysql\_fetch\_array($result);
    $msg\; .=\; "You\; have\; been\; removed\; from\; the$<i>" .
            row['listname'] . "</i> mailing list.<br />";
  } else {
    $msg\; .=\; "Sorry,\; could\; not\; find\; Mailing\; List\; id\#\{$ml_id}";
  }
  
  _GET['u'] .
          "'>Return to Mailing List Signup page</a>";
  echo $msg;\; ?>$