Are you a Google Analytics enthusiast?
More SEO Content
Automatic Date Related Pruning
Posted 23 May 2008 - 08:16 PM
Thanks in advance for any help and guidance.
Posted 24 May 2008 - 05:54 AM
or set/reset a flag to deactivate the entries.
Posted 24 May 2008 - 06:57 PM
Example: the entry for week begining Saturday 7th June should be automatically deleted when the actual date reaches the 8th June.
Posted 24 May 2008 - 09:19 PM
Either way you could do it with a simple MySQL delete statement as Chris laid out above, then set up a little cron job on a script to parse through the database table to figure out what needs to be deleted and what doesn't. Set up the server to fire it at 1am or something and you'd always be good to go without any daily hands on action.
Posted 25 May 2008 - 05:31 AM
Posted 25 May 2008 - 06:53 AM
Figure out how the date is being set originally before you even dig into the coding aspect. There are different formats (eg php date is not necessarily the same as using a MySQL date function) and knowing what is used to set the date initially will save you a lot of heartburn.
Posted 25 May 2008 - 10:12 AM
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users