<?php 
header("Content-Type: text/xml"); 
include("connection.php"); 
$stream = mysql_connect($host,$user,$password)or die("Connessione non riuscita: " . mysql_error()); 
mysql_select_db($db, $stream) or die("Errore nella selezione del database"); 
$sql = "SELECT * FROM ch_comments"; 
$query = mysql_query($sql) or die('Error, insert query failed'); 
echo "<?xml version=\"1.0\" encoding=\"ISO-8859-1\"?>"; 
while($result = mysql_fetch_array($query)){ 
    echo "<id>".$result['id']."</id>"; 
    echo "<title>".$result['title']."</title>"; 
    echo "<author>".$result['author']."</author>"; 
    echo "<latitude>".$result['latitude']."</latitude>"; 
    echo "<longitude>".$result['longitude']."</longitude>"; 
    echo "<content>".$result['content']."</content>"; 
} 
mysql_close($stream); 
?>