RSS is not that difficult to create.
You can easily create a function to generate your own custom RSS feed. I suggest you read a few sources to acquaint yourself with RSS and the different versions available.
What is RSS
RSS 2.0 Specification
Learn RSS from w3schools
A simple function would look something like this:
<?php
function rebuildRSS($rowID)
{
$rsstitle = 'A Sample RSS Feed';
$rsslink = 'http://www.phpbuilder.com/board/';
$rssdescrip = 'A quick description about the feed. In our case, it\'s about PHPBuilder!!';
$rsslang = 'en-us'; // US English
$query = sprintf("SELECT title, link, description FROM table WHERE id='%d'",
$rowID
);
$rslt = mysql_query($query);
if(!is_resource($rslt))
return false;
$rss = '<?xml version="1.0"'.'?'.'>
<rss version="2.0">
<channel>
<title><![CDATA['.$rsstitle.']]></title>
<link><![CDATA['.$rsslink.']]></link>
<description><![CDATA['.$rssdescrip.']]></description>
<language><![CDATA[en-us]]></language>';
while($row = mysql_fetch_assoc($rslt))
{
$rss .= '
<item>
<title><![CDATA['.$row['title'].']]></title>
<link><![CDATA['.$row['link'].']]></link>
<description><![CDATA['.$row['descrip'].']]></description>
</item>';
}
mysql_free_result($rslt);
// Here you will either save to a file, or echo out the feed.
// I've chosen to echo it for sake of simplicity.
echo $rss;
}
?>
That will take the row ID of the recently inserted row and generate a limited basic RSS 2.0 feed for you. But really, you should read up on the RSS spec and customize it to your needs.
I don't know of any pre-built rss generators out there, but you might check hotscripts.com
