Re: [PHP-DB] Dates - Best Approach

2007-09-10 Thread Goltsios Theodore
If you are using unix-like OSes then you could write a program or a script using (PHP, perl, bash, csh even C) whatever it suits you and use cron daemon to run it every month. This script should query the database and find out if is needed to be sent. The alternative (not the suggested so

[PHP-DB] Dates - Best Approach

2007-09-07 Thread Malcolm Clark
Hi! I am designing a contact management system, so that entries (client records) can be flagged, so that an email is sent out after 'n' months, to remind the user to contact this particular client. So, there would simply be a drop down menu with options: None, 1 month, 2 month, ... 12 months