unsubscribe

[timtom3]

Hi if I want to remove an item in my database for example an e-mail address for a table using a text box where the user enters there e-mail address then clicks unsubscribe, how would i get the e-mail address to check if its in the database

[ober]

[code]$query = SELECT emailaddressfield FROM mytable WHERE emailaddressfield = 'entered_email_address';
$result = mysql_query($query);
if(mysql_num_rows($result) > 0)
{
      // email address is in DB
}
else
{
     // it isn't in there
}[/code]