Sending emails to email addresses in a database

[turtleton09]

Can anyone let me know how to go about this?

Basically have a customer sign up form a site, where they can check a box to say they want to receive updates / offers etc.

So what I'm looking to do is enable the site owner to send emails to all those who have done so from the site.

ie get addresses from the email field in the cutomers table where the value of the receiveUpdates field = yes.

How would it typically work exactly - I imagine a form on a page where the owner can type in a title and message, hit a button that actions a php page that retrieves the correct records, and sends out the email.

Cheers.

[sid]

you could use a regular formmailer (there are tons of examples on the web and in tutorials), where the [man]mail/man function gets executed not once as usual, but for each row, that gets returned by your database query "SELECT email FROM database WHERE field = 'yes';" - which would be recipients for each email.

however, i dont want to go too much into depth, as i consider it a little iffy, when someone writes a potentially critical script like that, when not even being sure about the algorithm, let alone security issues.

[turtleton09]

Hi there,

I've been doing a bit of digging, and have just installed PHPlist :

http://www.phplist.com/

Should that sort thing be OK? As long as I get the functionality, that's the main thing - like a lot of these things, there's certainly no need to try to reinvent the wheel.