This topic is locked

email reminders

7/26/2007 11:45:17 AM
PHPRunner General questions
M
morpheus author

How can I email a set of records on a daily basis,
I have a table called items and one of the fields is called "amended_date", this is a date stamp for when the record was last altered,
there is also a field called "engineer", what I need to do is email a list of items that are 7 days old to each engineer, this needs to be triggered every morning, the idea is to remind them to return kit promptly.
regards
Morpheus

Sergey Kornilov admin 7/26/2007

Usually you need to write a script that checks for expired dates and sends out an email.
To run this script on timely fashion you need to setup a cron job. To create a cron job you can use the control panel that your web hosting company provides.

Here is the sample command that you can use:

wget http://www.yourwebserver.com/script_name.php