Let's take for example a shareware site. For the site to become popular, it has to be always up to date and to contain all the latest releases. So, the webmasters have to search for the new titles and add them to their databases. Many of them offer their visitors the possibility to stay informed about the latest releases using RSS feeds, which contain their names, links and short descriptions of the new releases. Visitors interested in this kind of information subscribe to the RSS feeds, using web-based or desktop aggregators, like Bloglines or SharpReader. All the aggregators query the RSS feeds every couple of hours, which is sufficient for many of the feeds, but not for all of them. It is a common practice that the feeds supply only the last 20 items, but what if, between two queries from the aggregators, appear, let's say, 43 items? Then, 23 of them wouldn't appear to the subscribers. Probably you've never thought about this, but I can assure you this situation really occurs, and you have to solve it, for you and your visitors' interest.

I will now show you a solution to this problem, implemented in PHP, one of the most used scripting languages on websites that are led by large databases. The main idea is that we will compare the date of the first and the 20th item, and if they are equal, we will run an extra query, to also add the other items that appeared in the database in the same day.

function additem($t, $l, $d) { $r= "<item>\n"; $r.="<title>$t</title>\n"; $r.="<description>$d</description>\n"; $r.="<link>$l</link>\n"; $r.="</item>\n";

return $r; } function create_rss() { $r ="<?xml version=\"1.0\"?>\n"; $r.="<rss version=\"0.91\">\n"; $r.=" <channel>\n"; $r.=" <title>Core Download - Latest 20 releases</title>\n"; $r.=" <link>http://www.coredownload.com/</link>\n"; $r.=" <description>The essential shareware and freeware downloads!</description>\n"; $r.=" <language>en-us</language>\n";

$q1="SELECT * FROM `products` WHERE 1 ORDER by p_added DESC LIMIT 0,20"; $result1 = mysql_query($q1); $i=0; while ($row = mysql_fetch_array($result1)) { $i++; if ($i==1) { $data1=$row[p_added]; } $r .=additem($row[p_name], $row[p_link], $row[p_description]); $data2=$row[p_added]; } if ($data1==$data2) { $q1="SELECT * FROM `products` WHERE `p_added`='$data2' LIMIT 20,1000"; $result1 = mysql_query($q1); while ($row = mysql_fetch_array($result1)) { $r .=additem($row[p_name], $row[p_link], $row[p_description]); } } $r.=" </channel>\n"; $r.=" </rss>\n"; echo $r; }

As you will see if you use this solution on your website, your feed's subscribers will find out about all your items (products, articles, or anything else), no matter how many they are. You can see this solution implemented on CoreDownload.com , a brand new shareware and freeware directory, that offers its visitors 3 RSS feeds: one for all the products, one for shareware and one for freeware.
About the Author