The "Freeola Customer Forum" forum, which includes Retro Game Reviews, has been archived and is now read-only. You cannot post here or create a new thread or review on this forum.
Right, so i have this database, and i need to automatically delete a record from the database if it has been on there for more than 2 weeks.
Any ideas, guys?
Any ideas, guys?
You need to format a column of your database to include a Unix timestamp, then set every page that is loaded to perform maintenance tasks such as this.
MySQL.
I need a command like
(database field date) = (todays date)
this is auto added when a recoed is added, and
(if (database field date) < (todays date-14 days)
delete record
I need a command like
(database field date) = (todays date)
this is auto added when a recoed is added, and
(if (database field date) < (todays date-14 days)
delete record
What type of database is it?
Right, so i have this database, and i need to automatically delete a record from the database if it has been on there for more than 2 weeks.
Any ideas, guys?
Any ideas, guys?