hvorfor vil den ikke slette emailen fra databasen
Jeg har sted hvor du kan framelde dig fra en mailingliste...Men den vil ikke rigtig slette ens fra databasen hvilken jeg ikke fatter...
//Koden
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Orinoco Pharma - kosttilskud, naturlægemidler, krops- og ansigtsplejeprodukter</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link href="../css/orinoco.css" rel="stylesheet" type="text/css">
</head>
<body>
<table width="100" border="0" cellpadding="0" cellspacing="0" class="bodyTable">
<tr>
<td valign="top">
<table width="100%" border="0" cellpadding="0" cellspacing="0" class="table">
<tr>
<td><br>
</td>
</tr>
</table>
<table border="0" align="center" cellpadding="0" cellspacing="0" class="table2">
<tr>
<td rowspan="2"> </td>
<td width="423"> <a href="../index.htm"><img src="../images/arrow.gif" width="7" height="5" border="0"> <strong>Hjem</strong></a> <a href="../om_orinoco/tilbyder.htm"><img src="../images/arrow.gif" width="7" height="5" border="0"> <strong>Om Orinoco Pharma</strong> </a><a href="../produkter/produkter.htm"><img src="../images/arrow.gif" width="7" height="5" border="0"> <strong>Produkter</strong></a> <a href="../information/information.htm"><img src="../images/arrow.gif" width="7" height="5" border="0"> <strong>Information</strong></a> <a href="../kontakt/kontakt.htm"><img src="../images/arrow.gif" width="7" height="5" border="0"> <strong>Kontakt</strong></a></td>
<td rowspan="2"><div align="right"><br>
<img src="../images/logo_stor.gif" alt="Orinoco Pharma" width="160" height="76"></div></td>
<td rowspan="2"> </td>
</tr>
<tr>
<td valign="bottom"> </td>
</tr>
<tr>
<td rowspan="2"><div align="right"><br>
<img src="../images/lefts/left1.jpg" width="140" height="275"></div></td>
<td colspan="2" valign="top" style="padding-left: 5px;"><br>
<br>
<img src="../images/overskrifter/orinocopharma.gif" width="175" height="14"><br>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td valign="top" style="padding-left:5px;"> <p><b><br>
Nyhedsbrev<br>
</b>Tilmeld dig nyhedsbrevet og få nyt fra os løbende <br>
<a href="tilmeld.php"><strong>Ønsker du at tilmelde dig, så tryk her</strong></a></p>
<form action="tilmeld.php" method="post">
<table>
<tr>
<td> Navn : </td>
<td>
<input type = "text" name = "name2">
</td>
</tr>
<tr>
<td> Email : </td>
<td>
<input type = "text" name = "email2">
</td>
</tr>
<tr>
<td> </td>
<td>
<div>
<input type = "submit" value = "Frameld" name="submit" class="knapper">
<input type = "reset" value = "Reset" name="reset" class="knapper">
</div></td>
</tr>
</table></form>
<?php
$name2 = $_REQUEST['name2'];
$email2 = $_REQUEST['email2'];
//removemenow.php
//dette script fjerner en bruger fra listen
if (!$email2 ==""){
$connection = mysql_connect("mysql.webglobe.dk","orinoco","orinoco04")
or die("cannot make connection");
$db = mysql_select_db("orinoco" , $connection)
or die("cannot find database");
$sql_query = "DELETE FROM email WHERE email = '".$_REQUEST['email2']."'";
$result = mysql_query("$sql_query") or die(mysql_error());
echo ("<b>Du er nu frameldt vores mailingliste</b>");
}
?>
<div align="center">
<p> </p>
</div> </td>
</tr>
</table> </td>
<td rowspan="2"><div align="left"><img src="../images/right_img.gif" width="53" height="258"></div></td>
</tr>
<tr> </tr>
</table>
<br>
<table border="0" cellpadding="0" cellspacing="0" class="table2">
<tr>
<td width="42%"><div align="right"><img src="../images/arrow.gif" width="7" height="5" border="0"> <a href="nyhedsbrev/tilmeld.php" style="color:#FF9210 "><strong>Nyhedsbrev</strong></a> </div></td>
<td width="58%">Copyright 2004/05 - All rights reserved | <a href="http://www.orinocopharma.com" target="_blank" style="color:#FF9210">Orinoco</a> - Site by <a href="http://www.framemakers.dk" target="_blank" style="color:#FF9210">FrameMakers</a></td>
</tr>
</table>
</td>
</table>
</body>
</html>
