ceeandcee 0 Junior Poster in Training

Good Evening...I have a number of RSS feeds that most readers can work with...

In some cases, they say it is not well formed, so I have tried to modify it. I think I am close. What am I missing?

<?xml version="1.0"?>
<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom">
<title>OH: All Hockey Stories found on OurHometown.ca</title>
<description>Here you will find a listing of all Hockey stories found on OurHometown.ca</description> 
// Make a MySQL Connection
// Get all the data from the db
$result = mysql_query("SELECT * FROM oh_stories where Sub_Category = 'Hockey' or Sub_Category2 = 'Hockey' order by Date DESC, Timestamp DESC Limit 0,10")
or die(mysql_error());  
// keeps getting the next row until there are no more to get
while($row = mysql_fetch_array( $result )) {
	// Print out the contents of each row into a table
	echo "<item>";
	echo "<title>";
	echo $row['Title'];
	echo "</title>";
	echo "<atom:link href='http://www.ourhometown.ca/".$row['Category']."/".$row['Story_Code'].".php' rel='self' type='application/rss+xml' />";
	echo "<guid>";
	echo "http://www.ourhometown.ca/".$row['Category']."/".$row['Story_Code'].".php";
	echo "</guid>";	
	echo "<description>";
	echo $row['Photo_Caption'];
	echo "</description>";
	echo "<pubDate>";
	echo ' ' .date('r', strtotime( $row['Timestamp'].' +1 hour') );
	echo "</pubDate>";
	echo "<enclosure url='http://www.ourhometown.ca/images/photos/".$row['Photo_Filename']."_S.jpg' length='78645' type='image/jpeg' />";
	echo "</item>";
echo "</channel>";
echo "</rss>"; 
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.