<?php 
$domene = 'localhost';
$namn = 'database';
$passord = 'databasepassord';
$database = 'krematoriet';
$tilkopling = mysql_connect($domene, $namn, $passord);
mysql_select_db ($database,$tilkopling);

$query = ("select count(*) from blogg where arkiv='1'");
$max = ((int)((mysql_result(mysql_query($query),0,"count(*)"))/1)-1);

$query = "select id, dato,tekst from blogg where arkiv='1' order by id desc limit 0,10";
$resultat = mysql_query($query);

header("Content-type: application/xml; charset=iso-8859-1");
?>
<<?php echo "?" ?>xml version="1.0" encoding="ISO-8859-1"  <?php echo "?" ?>>
<rss version="2.0" xmlns:content="http://purl.org/rss/1.0/modules/content/">
<channel>
  <title>Krematoriet</title>
  <link>http://www.krematoriet.net/</link>
  <description>Pretensi�st sj�lvforherligande vr�vl med ein dr�pe lime</description>
  <language>no-nyn</language>
  <generator>KrematorietCMS</generator>
  
  
  <?php
   for($i = 0; $i<10; $i++){
		 $row = mysql_fetch_array($resultat);
		 
		 $datotittel =  date("d.m.Y",strtotime($row['dato']));
		 $side =  $max-$i;
		 $skildring = $row['tekst'];
		 $dato = date("D, d M Y H:i:s O",strtotime($row['dato']));
		 
		 
		 echo ("
         <item>
         <title>Ubruklisme $datotittel</title>
         <link>http://www.krematoriet.net/?side=$side</link>
         <description>Kreative utspring fr� Krematoriet si framside.</description>
		 <content:encoded><![CDATA[$skildring]]></content:encoded>
         <pubDate>$dato</pubDate>
		 <guid>http://www.krematoriet.net/?side=$side</guid>
         
         </item>
         ");
	}
  ?>
  
  
</channel>

</rss>