[SOLVED] Dynamic RSS feed problem

[zhangy]

Hi,

I'm having problems with this php driven rss feed.

So far it loads the page title and description but the actual links in the feed don't show up; as seen here: http://eslassembly.com/test-feed.php

 

Can anyone see whats wrong in this code?

<?php
header("Content-type: text/xml");
echo "<?xml version=\"1.0\" encoding=\"UTF-8\"?>";
// Set RSS version.
echo "
<rss version=\"2.0\"> ";
// Start the XML.
echo "
<channel>
<title>ESL Assembly.com | Recent Job Openings</title>
<description>Follow the list of our most recent job posts for teaching English as a second language.</description>
<link>http://www.eslassembly.com/</link>";
// Create a connection to your database.
require("php/Load.php");
if (!mysql_connect($db_host, $db_user, $db_pwd))
    die("Can't connect to database");

if (!mysql_select_db($database))
    die("Can't select database");
// Query database and select the last 10 entries.
$data = mysql_query("SELECT * FROM $table ORDER BY submission_id DESC LIMIT 10");
while($row = mysql_fetch_array($data))
{
// Continue with the 10 items to be included in the <item> section of the XML.
echo "
<item>
<link>http://www.eslassembly.com/jobsDisplay.php?id=".$row[sub_id]."</link>
<guid isPermaLink=\"false\">http://www.eslassembly.com/jobsDisplay.php?id=".$row[sub_id]."</guid>
<title>".$row[col_A]."</title>
<description><![CDATA[".substr($row[col_B],0,450)."]]></description>
</item>";
}
echo "
</channel>
</rss>";
?>

[JonnoTheDev]

Your XML is invalid

[zhangy]

Sorry, I know next to nothing about xml. Is there something specific I can change in order to make it valid?

[zhangy]

Your XML is invalid

 

I've gone over and over it and everything looks copacetic.

I also put it into the w3c xml validator which resulted with no errors.

???