Good Evening...I have a number of RSS feeds that most readers can work with...
http://www.ourhometown.ca/rss/all/
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">
<channel>
<title>OH: All Hockey Stories found on OurHometown.ca</title>
<link>http://www.ourhometown.ca/sports/hockey/</link>
<description>Here you will find a listing of all Hockey stories found on OurHometown.ca</description>
<?php
// 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>";
?>