I am working on a listing site (www.togoenvogue.com) and need to set an auto deletion feature.
What I want is this. When the user wants to add a listing (job offer for example), he will need to select from a SELECT drop down how long he wants his message to be listed on the site. (field name can be "dropme")
For if he selects 1 month, the value would be 720 (hours).
Then I want to set an auto decrementation function that will reduce automatically DROPME value -1) every one hour.
So another function will automatically delete the message from the database when DROPME value is zero (something like DELETE FROM listingtable WHERE dropme ==0).
Any idea ?? Can somebody help me ???
Thank you in advance.