I am using the following PHP code to generate the XML for an RSS feed, but it doesn't seem to be working correctly. No short description is displayed in the feed reader, all I see is the title of the article. Also, all of the articles say they were published at the same time. This is the first time I have tried to setup an RSS feed, so I'm sure I've made several stupid
mistakes.
$result = mysql_query("SELECT * FROM blog ORDER BY id DESC LIMIT 10");
$date = date(DATE_RFC822);
header('Content-type: text/xml');
echo ("<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n");
echo ("<rss version=\"2.0\">\n");
echo ("<channel>\n");
echo ("<lastBuildDate>$date</lastBuildDate>\n");
echo ("<pubDate>$date</pubDate>\n");
echo ("<title>my website name</title>\n");
echo ("<description><![CDATA[the description]]></description>\n");
echo ("<link>http://my-domain.com</link>\n");
echo ("<language>en</language>\n");
$ch=100;
while ($a = mysql_fetch_array($result)) {
$headline = htmlentities(stripslashes($a['subject']));
$posturl = $a[perm_link];
$content = $a['post'];
$date = date(DATE_RFC822, $a['posted']);
echo ("<item>\n");
echo ("<title>$headline</title>\n");
echo ("<link>$posturl</link>\n");
echo ("<description><![CDATA[$content]]></description>\n");
echo ("<guid isPermaLink=\"true\">$posturl</guid>\n");
echo ("<pubDate>$date2</pubDate>\n");
echo ("</item>\n");
}
echo ("</channel>\n");
echo ("</rss>\n");
