...

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



briintex1
05-22-2008, 02:50 AM
Hello,
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.

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

syosoft
05-22-2008, 09: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



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum