<? header('Content-type: text/xml'); ?>
<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom">

<channel>
		<title>Coupon Connector</title>
		<description>Latest Deals and Discounts from around the web.</description>
		<link>http://www.couponconnector.com/</link>
		<copyright>Copyright LS Media 2011</copyright>
		<atom:link href="http://www.couponconnector.com/rss.xml" rel="self" type="application/rss+xml" />

			<?php

			$host = "localhost"; //database location
			$user = "ccadmin_dbadmin"; //database username
			$pass = "4*spammers!"; //database password
			$db_name = "ccadmin_mail"; //database name
			//database connection
			$link = mysql_connect($host, $user, $pass);
			mysql_select_db($db_name);

			//sets encoding to utf8
			mysql_query("SET NAMES utf8");

			# msg_id, msg_sent_date, msg_fromName, msg_subject

			$sqlstr = mysql_query("SELECT * FROM messages ORDER BY msg_id DESC LIMIT 0, 20 ");
				while ($row = mysql_fetch_array($sqlstr)) {

				?>

				     <item>
					<title><?=strip_tags($row['msg_fromName'])." - ".strip_tags($row['msg_subject']); ?></title>
					<description><?=htmlentities(strip_tags($row['msg_fromName']))." - ".htmlentities(strip_tags($row['msg_subject'])); ?></description>
					<link>http://www.couponconnector.com/details-<?=urlencode(htmlentities(strip_tags($row['msg_fromName'])));?>-coupon-<?=htmlentities(strip_tags($row['msg_id'])); ?></link>
					<guid>http://www.couponconnector.com/details-<?=urlencode(htmlentities(strip_tags($row['msg_fromName'])));?>-coupon-<?=htmlentities(strip_tags($row['msg_id'])); ?></guid>
					<pubDate><?=strip_tags($row['msg_sent_date']);?> EST</pubDate>
					
				 </item>

				<? 

				}
			
					
			?>


	</channel>
</rss>