Generate RSS Feed with PHP<?php
include('db.php');
$sql = "SELECT * FROM site_data ORDER BY id DESC LIMIT 20";
$query = mysql_query($sql) or die(mysql_error());
header("Content-type: text/xml");
echo "<?xml version='1.0' encoding='UTF-8'?>
<rss version='2.0'>
<channel>
<title>r-ednalan.blogspot.com | Programming Blog </title>
<link>http://r-ednalan.blogspot.com</link>
<description>Programming Blog </description>
<language>en-us</language>";
while($row = mysql_fetch_array($query))
{
$title=$row['title'];
$link=$row['link'];
$description=$row['description'];
echo "<item>
<title>$title</title>
<link>$link</link>
<description>$description</description>
";
}
echo "</channel></rss>";
?>
