Codezwiz >> Forums >> General PHP Nuke Help >> Help: Schedule email to be sent at regular intervals

Hey guys,

I'm trying to rig up an automatic newsletter that queries MySQL for some stuff and sends a formatted email on a weekly basis. Does anyone know how to set this up so that it sends automatically? I can do the whole emailer and SQL stuff, but not sure how to get it to run at regular intervals.

Running Windows 2003 Server Standard, IIS 6.0.

Okay, like clock work, eh?

Here's what I've decided. Let me know if you think this will work. I'm going to create a table called `prefix_timed_newsletter` and I'll have an identifier, a field called SENT (yes/no) and a field called SEND DATE. It's basically going to store 1 row of data.

Then I'll create a php function that selects the rows from that table where SEND DATE is equal to today's date and SENT is equal to NO. I'll do a numrows count on it and when numrows is greater than 0, I'll send out the email and update the `prefix_timed_newsletter` with a new SEND DATE and reset the SENT field to NO.

Then I'll just have to include this file in another module that gets hit at least once a day so it gets ran....will that work?

Sounds like it should work. Why not just set a cron job?

It's a Windows 2003 box. I've got a similar mod working right now, but I have to initiate on the admin side (Send Newsletter button).

Thanks Telli, you got me thinking. I created a scheduled task to open my browser and call the file.