unsubscribe a newsletter

[Anon]

Hai everybody, I just want to unsubscribe a particular user from a newsletter that he has subscribed. One way of achieving it is by getting his mail_id and setting a flag in the database. But how is it possible to unsubscribe him by sending a blank mail. Hope you get me.

Say I have a link reading
click this link to unsubscribe
blahblahblah?unsubscribe

by clicking this i should unsubscribe the user. How can i achieve it please help me out. Can anyone give me the code.
URGENT!!!

[Anon]

dude you answered your own question... are you just to lazy to type it out?!

url = yourdomain.com?action=unsubscribe&email=blah (@ char code) blah (. char code) com

/ verify email address and that they are allowed to unsubscribe... via cookies or a password, however you track users /

if($action=="unsubscribe" && $user_verified) {
mysql_query("UPDATE my_lame_spam_list SET subscribed='no' WHERE email='$email'");

or

mysql_query("DELETE FROM my_lame_spam_list WHERE email='$email'");

}

and while you are at it, make sure take my email out of your list please.