Spear Leaner

Have you ever thought of converting rss feeds to a database table?

There is benefit in having RSS feeds dump their items into a database. Having the rss items within a database allows you to use PHP functions to manipulate the data on a greater level.

This about it. You can now build up as many items as you would like, creating a table of 100+ rss articles. This database becomes a pool that you can draw from. You can create randomized lists, preventing the potential duplicate content issues that arise with using rss.

You can combine the information from multiple rss feeds into one table, allowing you to have an even greater variety of articles to choose from.

With PHP & MYSQL, you can empty out your gathered items wheneve you would like, or even run a cron job that runs the script every day at scheduled times. This will makes sure you are keeping the freash items in the mix, and clearing out the outdated items.

A pre-created program is RSS2MYSQL, this performs all the above mentioned and more. Check it out!