Automatic Scan of MYSQL records listed as Expired

[BLottman]

I don't understand how to have the hosting server scan records in one of my tables for records that have expired.

I have a table that contains two columns (i.e., DateListed and DateExpires).

I want to use the system to:
1. Scan the table on a Daily basis Automatically for records where the record's DateExpires column is within 5 days of the Current System Date.

2. When a match occurs, an email should be sent to the owner of the record indicating the time remaining before the record expires.

3. When the record's DateExpires Date exceeds the Current System Date, the record's "Disabled" Column should be changed to "Yes" so that the record is no longer displayed among the active records (i.e., those records that are between the DateListed date and the DateExpires Date).

I'd really appreciate any help on this one.

Thanks.

Bill Lottman
[e-mail]

[raymie]

If you are running under unix then what you want is a script running as a crontab....