[php]<?php

$output = '

<rss version="2.0">

	<channel>';

mysql_connect('localhost','user','pass');

mysql_select_db('news');



//set the content type to xml

header("Content-Type: text/xml");



$sql = mysql_query("SELECT * FROM news LIMIT 10");

while($res = mysql_fetch_array($sql))

{

	$title = $res['title'];

	$description = $res['description'];

	$author = $res['author'];

	$id = $res['id'];

	$link = "http://www.yoursite.com/news.php?id=$id";

	$output .= <<<EOT



		<item>

			<title>The Your Site News</title>

			<link>http://www.yoursite.com/</link>

			<description>$description</description>

		</item>

	

EOT;



}

$output .= '

</channel>

</rss>';

echo $output;



?>[/php]