Php sql xml

<?xml version="1.0" encoding="utf-8"?>
<markers>
   <name title="adres">
      <Naam>Maastricht</naam>
      <type>gemeente</type>

<?xml version="1.0" encoding="utf-8"?>
<markers>
   <name title="adres">
      <Naam>Maastricht</naam>
      <type>gemeente</type>

<?xml version="1.0" encoding="utf-8"?>
<markers>
    <marker address="Louis Jansenplein 1, Groningen" label="dit is een huis">
        <infowindow><![CDATA[<b>Dit is een huis</b><br/>Lees meer over <a href="http://www.eenwebsite.nl/" target="new">dit is een link</a>]]></infowindow>
    </marker>

<?xml version="1.0" encoding="utf-8"?>
<markers>
    <marker address="Louis Jansenplein 1, Groningen" label="dit is een huis">
        <infowindow><![CDATA[<b>Dit is een huis</b><br/>Lees meer over <a href="http://www.eenwebsite.nl/" target="new">dit is een link</a>]]></infowindow>
    </marker>

<?php
// STORE DATABASE VARIABLES
$hostname_cnConnection = "localhost";
$database_cnConnection = "go";
$username_cnConnection = "root";
$password_cnConnection = "*********";
$cnConnection = mysql_pconnect($hostname_cnConnection, $username_cnConnection, $password_cnConnection);
// CONNECT TO DATABASE
mysql_select_db($database_cnConnection, $cnConnection);
$query_rsRecordset = "SELECT * FROM markers";
$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 . "<markers>\n";
// STORE FIELD AND FIELD DATA IN ONE HIARCHY, REPEAT FOR MULTIPLE FIELDS
$strXML = $strXML . "   <name title=\"PrimaryID\">\n";
do {

$strXML = $strXML . "      <Naam>" . $row_rsRecordset['name'] . "</naam>\n";
$strXML = $strXML . "      <type>" . $row_rsRecordset['type'] . "</type>\n";


} while ($row_rsRecordset = mysql_fetch_assoc($rsRecordset));
$strXML = $strXML . "</markers>";
$strXML = $strXML . "   </name>\n";
// OPEN FILE, WRITE TO FILE, CLOSE FILE, CLOSE RECORDSET
$XMLFile = fopen("myxmlfile.xml", "w");
fwrite($XMLFile, $strXML);
fclose($XMLFile);

}
mysql_free_result($rsRecordset);
?>

<?php
// STORE DATABASE VARIABLES
$hostname_cnConnection = "localhost";
$database_cnConnection = "go";
$username_cnConnection = "root";
$password_cnConnection = "*********";
$cnConnection = mysql_pconnect($hostname_cnConnection, $username_cnConnection, $password_cnConnection);
// CONNECT TO DATABASE
mysql_select_db($database_cnConnection, $cnConnection);
$query_rsRecordset = "SELECT * FROM markers";
$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 . "<markers>\n";
// STORE FIELD AND FIELD DATA IN ONE HIARCHY, REPEAT FOR MULTIPLE FIELDS
$strXML = $strXML . "   <name title=\"PrimaryID\">\n";
do {
 
$strXML = $strXML . "      <Naam>" . $row_rsRecordset['name'] . "</naam>\n";
$strXML = $strXML . "      <type>" . $row_rsRecordset['type'] . "</type>\n";
 
 
} while ($row_rsRecordset = mysql_fetch_assoc($rsRecordset));
$strXML = $strXML . "</markers>";
$strXML = $strXML . "   </name>\n";
// OPEN FILE, WRITE TO FILE, CLOSE FILE, CLOSE RECORDSET
$XMLFile = fopen("myxmlfile.xml", "w");
fwrite($XMLFile, $strXML);
fclose($XMLFile);
 
}
mysql_free_result($rsRecordset);
?>

<?php
$str = '<?xml version="1.0"?>';
$str .= '<markers>';

$qry = mysql_query("select * from markers");
while($res = mysql_fetch_array($qry))
{
    $str .= '<marker address="'.$res['adres'].'" label="'.$res['label'].'">';
    $str .= '<infowindow>' . $res['type'] . '</infowindow>';
    $str .= '</marker>';
}
$str .= '</markers>';
?>

<?php
$str = '<?xml version="1.0"?>';
$str .= '<markers>';
 
$qry = mysql_query("select * from markers");
while($res = mysql_fetch_array($qry))
{
    $str .= '<marker address="'.$res['adres'].'" label="'.$res['label'].'">';
    $str .= '<infowindow>' . $res['type'] . '</infowindow>';
    $str .= '</marker>';
}
$str .= '</markers>';
?>