Looking for some direction here.
Here is what I have:
Pulling events from a MySQL database end inserting into an email based on requested state requirements in an email list (single state, all states) and then only if there are newer entries than the last email received.
Possible news entry in the same email, and then again only sent if user had requested to receive such updates
Possible sponsor information, same criteria as the news.
Here is what I need to have happen:
Based on mailing list information, news, new event entries and sponsor information all need to be emailed to each individual from the mailing list database. Some get all 3, some get one, some get a combination.
My question is, where do I begin to not only create a formatted email, but have the correct information sent to the proper email. I'm looking for a way to add or not add and have it work out for me. Below is my theoretical on what I would like to have happen.
Do until entire email list has been run through.
-If news/site update article exists, add to email function else skip
-If new event, add to email function, do until all events in event database has
been run through since last email. If no new info, skip.
-If new sponsor ad, add to email if requested, else skip.
-Go to next email.
Any assistance or direction would be excellent!
Thanks
Shawn
