You could do this with PHP.
insert story into database;
do {
get subscriber email address;
send email with link to story;
} until no more subscribers
If you have a lot of subscribers you'd be better off with a proper list
manager, though.
HTH
Jon
-----Original Message-----
From: kaab kaoutar [mailto:[EMAIL PROTECTED]]
Sent: 30 May 2001 10:29
To: [EMAIL PROTECTED]
Subject: how to setup a Newsletter?
Hi!
I'working with php/mysql and id like to set a news letter!
can u guide me through how to trigger sending an email once an article is
inserted to my table in the database?
i mean i want emails to be sent to all subscribers (stored in subscribers
table) once an article is inserted in the articles database ! the aim is to
automate it without human intervention!
Thanks
**********************************************************************
'The information included in this Email is of a confidential nature and is
intended only for the addressee. If you are not the intended addressee,
any disclosure, copying or distribution by you is prohibited and may be
unlawful. Disclosure to any party other than the addressee, whether
inadvertent or otherwise is not intended to waive privilege or confidentiality'
**********************************************************************
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
