<?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;

 
?>