Hi, i'm kind of new to this so i would greatly appreciate some help.
I'm trying to set up an email processing system that runs in the background. The code needs to be run on an event-driven basis and needs to send information stored in a mysql database. Basically, when a user updates our database, we need to automatically send an email out to a list of users. I could do this with a while loop inside the php, but this would cause the user to wait on the loop to exit, which would be painfully slow. Also, we need to make sure that emails go out successfully.
I've tried working with phplist, but i could not figure out how to send emails to a defined list from inside my php scripts. I dont want to manually send emails. Also, need to be able to add people to lists very simply, just by adding their info to a mysql table, not subscription based.
Can someone help me? I know there is software out there to do this, but i cant seem to find what i need.
I've also been considering setting up a cron job to run every 5 minutes. The job would inspect a mysql table for unsent emails and send them. Is this crazy?
