simple MYSQL help. delete from a html form
Posted: Sat Apr 11, 2009 10:48 am
i have a very simple form that adds to a mailing list database now i need to delete from that databass with a similar form, strangely finding this hard.
here is the form:
<html>
<body>
<form action="delete1.php" method="post">
Email: </br>
<input type="text" name="email" /> </br>
<input type="submit" name="submit" />
</form>
</body>
</html>
this is simple stuff that i can delete from my database from, however iv been trying a few things to link the two.
<?php
$con = mysql_connect("localhost","root","");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("slumtramp", $con);
mysql_query("DELETE FROM mailinglist WHERE email=''");
mysql_close($con);
?>
i'm sure this is a simple as hell fix but im stumped. any help would be great. thanks.
here is the form:
<html>
<body>
<form action="delete1.php" method="post">
Email: </br>
<input type="text" name="email" /> </br>
<input type="submit" name="submit" />
</form>
</body>
</html>
this is simple stuff that i can delete from my database from, however iv been trying a few things to link the two.
<?php
$con = mysql_connect("localhost","root","");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("slumtramp", $con);
mysql_query("DELETE FROM mailinglist WHERE email=''");
mysql_close($con);
?>
i'm sure this is a simple as hell fix but im stumped. any help would be great. thanks.