Subscription mailing list

[robert]

Hi All

Im building my first php site and what im looking for is a simple
tutuorial / example of a form which allows users to enter their email
address, which is stored in my Mysql db.

Also need to know how to go about mailing everyone who subscribes to
my news letter.

I know its probably quite simple, but i'd like to check for duplicate
email addresses, verify email addresses (dont know if that possible)
and allow them to un-subcribe.

Thanks in advance.
Robert, Inverness

[Alvaro G Vicario]

Re: Subscription mailing list

*** robert wrote/escribió (6 Nov 2003 08:39:29 -0800):[color=blue]
> but i'd like to check for duplicate email addresses[/color]

You can either make e-mail database field a unique key or, simply, perform
a SELECT query before inserting new addresses in order to check whether
user is already subscribed.
[color=blue]
> verify email addresses (dont know if that possible)[/color]

Add the address to a temporary table with a unique random id (like
kyzaxa3epada3ix y). Then send a message with instructions to activate the
account: "Visit http://www.site.com/activate.php?id =kyzaxa3epada3i xy".
In activate.php, check code exists, add data to final table and remove
temporary entry.
[color=blue]
> and allow them to un-subcribe.[/color]

It's almost the same as subscribing, just replace "INSERT" with "DELETE"
;-)

--
--
-- Álvaro G. Vicario - Burgos, Spain
--