<?php // Start XML file, create parent node $xml = new XMLWriter(); $xml->openMemory(); $xml->startDocument('1.0', 'UTF-8'); //markers $xml->startElement('markers'); //close markers $xml->endElement(); //write to file file_put_contents('markers.xml', $xml->outputMemory()); // Iterate through the rows, adding XML nodes for each while ($row = @mysql_fetch_assoc($result)) { // ADD TO XML DOCUMENT NODE $node = $xml->create_element("marker"); $newnode = $parnode->append_child($node); $newnode->set_attribute("name", $row['name']); $newnode->set_attribute("address", $row['address']); $newnode->set_attribute("lat", $row['lat']); $newnode->set_attribute("lng", $row['lng']); $newnode->set_attribute("type", $row['type']); }