Member Avatar for kamaster

Hallo.

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.

Kamaster

  • 3 Contributors
  • 2 Replies
  • 121 Views
  • 8 Hours Discussion Span
  • Latest Post Latest Post by R0bb0b
Member Avatar for andyhoneycutt

I would do this:
1. Make a "created" field for the item submitted that defaults to CURRENT_TIMESTAMP value. This will be the time that the record is submitted.
2. Make another field called "expires" and procedurally set it's value to the value of "created" + "DROPME".
3. Create a php or perl script that runs every hour through the crontab and either marks old records inactive (where "expires" <= NOW()) or just deletes them.

-Andy

Member Avatar for R0bb0b

Or you could look into creating a trigger, which is the way I would go.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.