Can someone tell me if there is a way to remove old articles. If so, how?
Solution by BJC Computer Services http://www.bjc-computer-services.com
Here is the SQL command to delete articles by date. Change 'tbl_name' to the name of your actual articles table, and change the date to whatever you need. This command will delete everything posted previous to that date.
- Code: Select all
DELETE FROM tbl_name WHERE `posteddate` < '2007-05-01'
Just go to phpMyAdmin, Select your database, then Select your table name, then Select the SQL button at the top of the screen, and paste in the command with the changes you made and select GO.
I suggest that you start with the single oldest date to make sure it works as you expect, then expand the date after verifying the results you need.
As always, backing up your table ahead of time is a good idea in case of problems. Then you can always restore the backup if necessary.
