<?php
error_reporting(0);
include("include.php");
echo '<?xml version="1.0" ?>';
?>

<rss version="2.0">
<channel>
	<title>Blog</title>
	<description>latest 10 post</description>
	<link></link>
<?php
	$sql = "SELECT * FROM ".$TABLES["POSTS"]." ORDER BY published_on DESC";
	$sql_result = mysql_query ($sql, $connection ) or die ('request "Could not execute SQL query" '.$sql);
	while ($POST = mysql_fetch_assoc($sql_result)) {
?>
	<item>
		<guid isPermaLink='false'><?php echo $POST["id"]; ?></guid>
		<title><![CDATA[<?php echo ReadFromDB($POST["title"]); ?>]]></title>
		<description><![CDATA[<?php echo ReadHTMLFromDB($POST["body"]); ?>]]></description>
	</item>
<?php }; ?>
</channel>
</rss>