header('Content-Type: application/xml; charset=iso-8859-15');
$root=preg_replace("/(^.*\/).*$/","$1",(preg_match("/^\//",$_SERVER['REQUEST_URI'])?('http://'.$_SERVER['HTTP_HOST']):'').$_SERVER['REQUEST_URI']);
echo '<'.'?xml version="1.0" encoding="ISO-8859-15" ?'.'>';
$i=0;
$link = mysql_connect(SERV, LOGIN, MDP);
if($link)
{
mysql_select_db(DB);
$result = mysql_query ('SQL QUERY');
if($result)
{
$item='';$ch=array();
//generate the list of items
while($row=mysql_fetch_array($result))
 {
 $linkurl=$root.'agenda.php?a='.$row['id'].'#a'.$row['id']; // the item's link
 $item.='<item xlink:type="simple" xlink:show="replace"  xlink:href="'.$linkurl.'" rdf:about="'./*the Item's URI */.'">';
 $item.='<title>'.cl($row['titre']).'</title>';
 $item.='<link>'.$linkurl.'</link>';
 $item.='<dc:date>'.date("Y-m-d",$row['date']).'</dc:date>';
 $item.='<description>'.cl($row['text']).'</description>';
 $item.='<dc:creator>'.cl($row['posteur']).'</dc:creator>';
 array_push($ch,$the_Item_URI);
 $item.="</item>\n";
 }

?><rdf:RDF  xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#"  xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:ical="http://www.w3.org/2002/12/cal/ical#" xmlns:foaf="http://xmlns.com/foaf/0.1/"     xmlns:xlink="http://www.w3.org/1999/xlink" xmlns="http://purl.org/rss/1.0/" xml:lang="fr" xml:base="<?php echo $root; ?>">
<channel  rdf:about="<?php echo $root.'agenda.php'; ?>">
<title><!-- Your title --></title>
<link><!-- your link --></link>
<description><!-- your description --></description>
<dc:language>en</dc:language>
<items>
<rdf:Seq>
<?php
for($i=0;$i<count($ch);$i++)
{
echo '<rdf:li rdf:resource="'.$ch[$i].'" />';
}
?>
</rdf:Seq>
</items>
</channel>
<?php
echo $item;
?>
</rdf:RDF>
<?php
}
}
?>