deleting entries from a table

[Anon]

O.k I have managed to create my table in mysql. table name= email_info

I have managed to insert 2 fields, name and email address.

namefield = $fullname
emailfield = $email

The user can add there name and email to the database via a form. I can then display these results via another page.

Does anyone have a sample script that can delete individual entries via a form. All help would be much appreciated.

[katia]

Here's a quick one:

<?
if (!submit) {
//database connection stuff here
.
.
$query = mysql_query("select name,email from user where id = '$id'");
$row = mysql_fetchrow($query);
?>
<form action=<? echo $PHP_SELF ?> method=post>
Name: <input type=text name=name value=<? echo $row[0] ?>><br>
Email: <input type=text name=email value=<? echo $row[1] ?>><br>
<input type=submit value="Remove Me">
</form>
<?
} else {
mysql_query("delete from user where email='$email'");

?>
You've been removed.
<?
}
?>

A caveat: I've not tested this. But it should work.

[Anon]

Thank you very much Kat.

Many Thanks
Adrianuk