Page 1 of 1

Myql - check something at regular intervals...

Posted: Sat Mar 20, 2004 1:18 pm
by nads1982
I have a mysql database of members and the money they owe. I would like to send an email to a member if they owe x amount for longer than x days...

any suggestions

any help MUCH appreciated :oops:

Posted: Mon Mar 22, 2004 8:08 am
by THESiUS
You could use a cron job.

Posted: Mon Mar 22, 2004 9:45 am
by JAM
[google]run php script using cron[/google] as said or else you need to do a check (like: "select user from table where ownage > 'X' and duedate < 'X days ago'") each time someone touches the database.

The last takes abit effort and might also cause high usage on the database if its called oh so very often... Just mentioning it.