Hello
I have some records in a mysql database which indicate the expiry date for something. I would like to run a cron command which will look in the database and identify records (by sending an email) when the expiry date of a record is within a certain number of days of some other specified date.
Could anyone please point me to a program or a website with the solution (or likely to have the solution)? I suspect it is not possible to do this in PHPRunner, but maybe it is...
Thank you
Andrew