<?xml version="1.0" encoding="UTF-8" ?>

<?xml version="1.0" encoding="iso-8859-1"?>
<rss version="2.0">

  <channel>
    <title>news</title>
    <link></link>
    <description></description>
    <language>de-de</language>
    <copyright>copyright 2002-2006</copyright>

<?php 

	include('includes/config.php');
	$sql = "select * from news ORDER by n_id DESC LIMIT 6";
	$ausgabe = mysql_query($sql);
	while($news = mysql_fetch_array($ausgabe)) {

?>

	<item>
      <pubDate><?php echo datumdt($news[n_datum]); ?></pubDate>
      <title><?php echo "$news[n_headline]"; ?></title>
      <description><?php echo nl2br($news[n_text]); ?></description>
      <link></link>
    </item>
	
<?php } ?>

  </channel>

</rss>

<?php

$rss_header ='<?xml version="1.0" encoding="iso-8859-1"?>
<rss version="2.0">

  <channel>
    <title></title>
    <link></link>
    <description></description>
    <language>de-de</language>
    <copyright>copyright 2002-2006</copyright>';
	
	
$rss_footer ='</channel>

</rss>';

	$content=$rss_header;

	$dbhost = "localhost";
	$dblogin = "xxxxx";
	$dbpasswd = "xxx";
	$dbname = "xxxx";

    mysql_connect($dbhost, $dblogin, $dbpasswd) or die("Verbindung zur Datenbank fehlgeschlagen");
	mysql_select_db($dbname);
	
	$sql = "select * from news ORDER by n_id DESC LIMIT 6";
	$ausgabe = mysql_query($sql);
	while($news = mysql_fetch_array($ausgabe)) {

	$content.='<item>
      <pubDate></pubDate>
      <title>$news[n_headline]</title>
      <description>echo nl2br($news[n_text])</description>
      <link>$news[n_id]</link>
    </item>';
	
	}
	
	$content.=$rss_footer;
	
	echo "$content";
	return;
	
?>