View Full Version : Delete a db entry after a certain amount of time.

05-22-2008, 03:50 AM
I was wondering if you could tell me if this is possible? Can PHP delete an item that is in a db after 7 days or 168 hours?

I am going to be inserting items into a database through a form, and was wanting an item to be deleted after 168 hours. Therefore I can't go and manually adjust my time each time sometime is inserted into a database. Can you let me know where I should start?

I am off to look at google, but I wanted to start here.

05-22-2008, 03:53 AM
Using a Cron Job, you can run a script which deletes the record.

05-22-2008, 10:52 AM
If you're not familiar with cron, run a single query every time a page is loaded (or form submitted).

DELETE FROM table WHERE DATEDIFF(NOW(), created_date) > 7