Please help to improve my skill.

Recommended Answers

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 meeting, learning, and sharing knowledge.