Deleting a record based on the system date/time?

[Solarpitch]

Hey Guys ,

I have an application that involeves user's uploading an add to sell a product. The user gets to select whether they want the add to run online for..

1 day
3 days
5 days
1 week

Is there a way or some code that I can use that automically removes the add from the database, based on the system date and time?

So if user selects 1 day . . 24 hours from the time it was uploaded it will be automatically deleted or better still . .  deleted and stored in an admin table!

Cheers,
Gerard.

[Barand]

[code]
<?php

$period = 5;  // how many days

$expiry_date = date('Y-m-d', strtotime("+$period days"));
?>
[/code]


Write the expiry date to the ad record.

To remove old records

mysql_query ("DELETE FROM ads WHERE expiry_date < CURDATE()");

[Solarpitch]

Thats simple huh! lol . . brilliant . . thanks a mill! :)