Please help to improve my skill.

Recommended Answers

How about you start by taking the time to more clearly describe your problem?

Jump to Post

All 2 Replies

How about you start by taking the time to more clearly describe your problem?

The general design for this sort of thing is called "data expiration" and "garbage collection." You put a DATETIME column into the database table that gives the expiration date of the row. After your initial connection to the database, you use a DELETE query something like this (pidgin code):

DELETE FROM mytable WHERE expiration_date < NOW()

HTH, Ray

Be a part of the DaniWeb community

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