Displaying an RSS feed using PHP/MySQL

programming
1

Hi,

Having a bit of trouble with my feed.

I have a mySQL database storing my news updates, and I’m trying to get an RSS feed from that, using php.

Heres my code:

<?php
include "dbconnect.php";

header('Content-type: text/xml');
echo '<?xml version=\'1.0\' encoding=\'UTF-8\'?>';

echo '
<rss version=\'2.0\'> ';

echo '
<channel>
<title>Proud Noise</title>
<description>News update feed for Proud Noise</description>
<link>http://www.houseofpod.net/proudnoise/</link>';

$data = mysql_query('SELECT * FROM proudnoise_update ORDER BY id DESC');
while($row = mysql_fetch_array($data))
{
echo '
<item>
<title>'.$row['title'].'</title>
<link>http://www.houseofpod.net/proudnoise/</link>
<description>'.$row['news'].'</description>
<pubDate>'.$row['date'].'</pubDate>
</item>';
}
echo '
</channel>
</rss>';

?>

Again, I’ve stripped everything down to the bare minimum to try to find the root of the problem, but its just not working! If I check the source code of the file on the server, everything seems to be in order, and it looks like a normal rss feed with the data taken from the database, but the actual feed only displays the Channel, Title ect part at the top.

I’m fairly new to all this, am I doing something wrong? Can anyone help please?