Myql - check something at regular intervals...

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
nads1982
Forum Newbie
Posts: 9
Joined: Sat Feb 21, 2004 2:37 pm

Myql - check something at regular intervals...

Post 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:
THESiUS
Forum Newbie
Posts: 6
Joined: Wed Mar 17, 2004 2:53 am

Post by THESiUS »

You could use a cron job.
User avatar
JAM
DevNet Resident
Posts: 2101
Joined: Fri Aug 08, 2003 6:53 pm
Location: Sweden
Contact:

Post 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.
Post Reply