Forum Moderators: coopster
Currently I'm managing a rather large project for the international sporting event. I took over the project a few weeks ago, and now the guy who is a general manager for the project wants the following:
Currently, attendees are going trough a series of webforms to sign up for the event. Among the other info, they are asked to provide two emails for the contact, primary and secondary one. Those are stored in a mysql field, and I have no problem SELECT-ing them via php and mysql. BUT, now the guy wants that those who signup (about a hundred users so far and growing) and the future ones to be able to send them some notices about the event itself, but wants to avoid the step where users are required to signup to the mailing list.
What this means is that I have to find out the way that I signup the current users to some mailing list but at the same time to think on the future users, and when they signup up for the event that they enter the database for the mailing list, too, WITHOUT NOTICING THEM that they are subscribed. I know this is unethical (I mentioned that to the GM) but honestly speaking, the majority of those users don't like those "subscribe today" things, and the info that would be given to them is rather important for the event itself.
Can you suggest me some solution?
why do you need a seperate list? You have all the email addresses in your table already. When you want to send out the notices just pull the whole list of emails from your table.
I don't really see any reason to duplicate them into another table. I assume I am missing something.
Errr, maybe I didn't explain my situation good enough.
In general, all I want is to send email notices to the subscribers without having them to subscribe first.
I wanted to do this with some kind of newsletter manager, but I googled a bit and found out that the most simple solution is that I simply pull the emails from a table, put the in a $string and then user mail() function for each row seperatly.
Page timeout doesn't bother me :)
I have done the same thing, slow release, 50 emails every 5 or 10 mins on cron until the list is done, not really very complicated. I use a flag to tell me which members already received the email and select the next 50 and send them.
