<?php header('Content-type: text/xml'); ?>
<rss version="2.0">
<?php require 'inc/db_conn.php'; ?>
<channel>
<title>Anchorage Wines</title>
<description>Anchorage Wines news</description>
<link>http://www.anchoragewines.co.nz/index.php</link>
<copyright>copyright Anchorage Wines</copyright>
<?php
	$query = "SELECT * FROM `news` WHERE `position`=1;";
	mysql_query($query, $link) or die("Error executing MySQL query:<br />\n&raquo;$query&laquo;<hr />\nMySQL Error:<br />\n".mysql_error($link)."<hr />\n");
	$result = mysql_query($query, $link) or die("Error executing MySQL query:<br />\n&raquo;$query&laquo;<hr />\nMySQL Error:<br />\n".mysql_error($link)."<hr />\n");
	while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){
		$title = htmlentities(strip_tags($row['title'],'ENT_QUOTES'));
		$description = htmlentities(strip_tags($row['text'],'ENT_QUOTES'));
		$title_nospaces = str_replace(' ', '_', $title);
?>
    <item>
        <title>Anchorage Wines' news: <?php echo $title ;?></title>
        <description><?php echo $description ;?></description>
        <link>http://www.anchoragewines.co.nz/index.php?title=<?php echo $title_nospaces ;?></link>
        <guid isPermaLink="true">http://www.anchoragewines.co.nz/index.php</guid>
    </item>
<?php } ?>
</channel>
</rss>