Please help to improve my skill.
praise23 0 Newbie Poster
Recommended Answers
Jump to PostHow about you start by taking the time to more clearly describe your problem?
All 2 Replies
Reverend Jim 5,225 Hi, I'm Jim, one of DaniWeb's moderators. Moderator Featured Poster
How about you start by taking the time to more clearly describe your problem?
Ray Paseur 44 Newbie Poster
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, networking, learning, and sharing knowledge.