Hi
I have looked around the forum but cant find anything about rss feed links. I have managed to get my rss feed working but i want users to be able to click on the title of the rss to take them bk to the orignal website can anyone tell me how to do this.
<?
$dbServer=mysql_connect("localhost","","");
if (!$dbServer) {echo "Failed to connect to MySQL"; exit; }
mysql_select_db("",$dbServer);
// Get latest items from db
$sql = "SELECT * FROM messages ORDER BY date_added DESC limit 0,10";
$rst = mysql_query($sql);
// Loop through data and build feed items
$items = "";
while($a_row = mysql_fetch_assoc($rst))
{
$items.= "<item>";
$items.= " <title>{$a_row['title']}</title>";
$items.= " <link>{$a_row['link']}</link>";
$items.= " <description>{$a_row['message']}</description>";
$items.= " <description>{$a_row['date_added']}</description>";
$items.= "</item>";
}
// Build feed text
$feed = "<?xml version=\"1.0\"?>";
$feed.= "<rss version=\"2.0\">";
$feed.= " <channel>";
$feed.= " <title> blog feed</title>";
$feed.= " <link>http://mi-linux.../~/index.php</link>";
$feed.= " <description>A cool feed</description>";
$feed.= " $items";
$feed.= " </channel>";
$feed.= "</rss>";
// Display feed text
echo $feed;
?>