// STORE DATABASE VARIABLES
  $hostname = "host";
  $database = "db";
  $username = "user";
  $password = "pass";
  $cnConnection = mysql_pconnect($hostname, $username, $password);
  
  // CONNECT TO DATABASE
  mysql_select_db($database, $cnConnection);
  $query_rsRecordset = "SELECT * FROM notizie ORDER BY ID DESC";
  $rsRecordset = mysql_query($query_rsRecordset, $cnConnection) or die(mysql_error());
  $row_rsRecordset = mysql_fetch_assoc($rsRecordset);
  $totalRows_rsRecordset = mysql_num_rows($rsRecordset);
  
  // START STORING DATA IN VARIABLE TO PLACE IN XML FILE
  if($totalRows_rsRecordset > 0) {

 $strXML = "<?xml version=\"1.0\"?>\n";
    
  // STORE NAME OF TABLE
  $strXML = $strXML . "<notizie>\n";
  
  // STORE FIELD AND FIELD DATA IN ONE HIARCHY, REPEAT FOR MULTIPLE FIELDS
  do {
  $strXML = $strXML."<notizia>\n";
  $strXML = $strXML."<id>".$row_rsRecordset['ID']."</id>\n";
  $strXML = $strXML."<titolo> ".$row_rsRecordset['titolo']." </titolo>\n";
  $strXML = $strXML."<descrizione> ".$row_rsRecordset['descrizione']." </descrizione>\n";
  $strXML = $strXML."</notizia>\n";
  
  } while ($row_rsRecordset = mysql_fetch_assoc($rsRecordset)); 
  
  $strXML = $strXML . "</notizie>";
  
  // OPEN FILE, WRITE TO FILE, CLOSE FILE, CLOSE RECORDSET
  $XMLFile = fopen("notizie_xml.xml", "w") or die("can't open file");
  
  fwrite($XMLFile, $strXML);
  fclose($XMLFile);
}
  mysql_free_result($rsRecordset);