hvorfor slettes data ikke fra tabellen
HejsaJeg sidder og fifler med et maillistescript i php, der er baseret på mysql, det går helt fint med at oprette modtagere, som også får en mail sendt som de skal, men når man vil slette en emailadresse lader det sig tilsyneladende ikke gøre, der bliver alligevel sendt en mail, på trods af at den skulle være slettet, sovse ser ud som følger:
<html>
<head>
<title>Remove from mailing list</title>
</head>
<body>
<center>
<TABLE WIDTH="241" BORDER="1" CELLSPACING="0" CELLPADDING="0">
<FORM ACTION="remove.php" METHOD="POST"> <CAPTION ALIGN="TOP">Remove From Our Mailing List</CAPTION>
<TR>
<TD WIDTH="238">
Email: <INPUT NAME="email" TYPE="text" SIZE="25"></TD>
</TR>
<TR>
<TD WIDTH="238" align="center"><input type="submit" value="Remove"></TD>
</TR>
</FORM>
</TABLE>
</center>
</body>
</html>
<?
include("settings.inc");
mysql_connect("$dbhost","$dbuser","$dbpass");
$query1 = mysql_db_query($dbname, "select id from mailinglux where email='$email'");
$res_query1 = mysql_num_rows($query1);
if($res_query1 < 1) {
echo "The email address you submitted isn't in our database. Please double check it and try again.";
exit;
}
else {
mysql_db_query($dbname, "delete * from mailinglux where email='$email'");
echo "Your email has been removed from our mailink list. You will receive a confirmation soon.";
mail("$email","Your email address has been removed","Hello,\n\nYour email address has been remove from our mailinglist\n\nThank you\n\n________________________","From:$support");
}
?>
