<?
include_once "db.cinch";
connect();

// get all news entries
$getNews = mysql_query("SELECT * FROM press_releases ORDER BY date_posted DESC");
echo "<?xml version='1.0'?>\n";
echo "<?xml-stylesheet type='text/xsl' href='rss-display.xsl' version='1.0'?>";
echo "<rss version='2.0'>\n";
echo "	<channel>\n";
echo "		<title>Cinch Connectors News</title>\n";
echo "		<link>http://www.cinch.com/view_news.cinch</link>\n";
echo "		<description>Get all the latest updates from Cinch Connectors</description>\n";
echo "		<language>en-us</language>\n";
echo "		<webMaster>webmaster@cinch.com</webMaster>\n";
while ($row=mysql_fetch_array($getNews)){
	$row['title'] = str_replace("™","",$row['title']);
	$date_posted = date("D, j M Y h:i:s", $row['date_posted']);
	echo "		<item>\n";
	echo "			<title>".$row['title']."</title>\n";
	echo "			<link>http://www.cinch.com/view_news.cinch?pr_id=".$row['id']."</link>\n";
	echo "			<description>".$row['title']."</description>\n";
	echo "			<pubDate>".$date_posted." CST</pubDate>\n";
	echo "		</item>\n";	
}
echo "	</channel>\n";
echo "</rss>\n";
?>