# Php responder with remove id

**URL:** <https://forum.kirupa.com/t/php-responder-with-remove-id/167161>\
**Category:** Uncategorized\
**Created:** [October 25, 2005, 10:58pm UTC](https://forum.kirupa.com/t/php-responder-with-remove-id/167161 "2005-10-25T22:58:29Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![imbuez](https://yyz1.discourse-cdn.com/flex011/user_avatar/forum.kirupa.com/imbuez/32/645_2.png) [@imbuez](https://forum.kirupa.com/u/imbuez)\
**Post date:** [October 25, 2005, 10:58pm UTC](https://forum.kirupa.com/t/php-responder-with-remove-id/167161/1 "2005-10-25T22:58:29Z")

</div>

Hi Folks.  
Im hoping that somebody could share their knowledge with me please. I have a database whcih collects the email address and name from a flash form. Im having no problem inserting this into my database 😉

I am trying to set up a responder which will pull the unique ID out from my databse soas to give the subscribe the option to ‘opt out’ as it were.

This is where i seem to be coming unstuck. I can post my code that i have been playing with so far.

```php

<?php
	 //Capture data from $_POST array
	 $name = $_POST['name'];
	 $email = $_POST['email'];
//$date = date("Y-m-d G:i:s") ;
$tz = 5; 
$hour = date("g"); 
$time = date(":i"); 
$daytime = date("A"); 
$hour = $hour + $tz; 
$realTime = $hour.$time.$daytime; 
 
$date = date('l, d. F Y'); //Output: Wednesday, 07. September 2005
	 //Connection to database
	 $connect = mysql_connect("xxx", "xxx", "xxx");
	 mysql_select_db ("bevayne_email", $connect);
	 //Perform the query
	 $result = mysql_query("INSERT into myList (name,email, date) values ('$name','$email','$date $realTime')");
	 if($result) { 
echo "writing=Ok&";
}
	 else echo "writing=Error";
?> 
// this is here just for my testing purposes 
 
<? 
$to = "$email"; 
$subject = "Bevaybe News letter"; 
$message .= "Email: $email 
"; 
$message .= "$name Thanks you for your interest. Please remove yourself via this link<br/><a href=\"http://www.bevayne.co.uk/scripts/delete.php?id=$id\" title=\"Delete Email Address\">Remove Me Please</a>"; 
$header = "From: info@bevayne.co.uk"; 
mail($to, $subject, $message, $header);
?> 

```

Thanks in advance