'; // Start XML file, create parent node $dom = new DOMDocument("1.0"); $node = $dom->createElement("markers"); $parnode = $dom->appendChild($node); // Search the rows in the markers table $result = mysql_query("SELECT * FROM markers WHERE MATCH ( name ) AGAINST('".$name."' IN BOOLEAN MODE)"); if (!$result) { die("Invalid query: " . mysql_error()); } // Iterate through the rows, adding XML nodes for each while ($row = @mysql_fetch_assoc($result)) { $node = $dom->createElement("marker"); $newnode = $parnode->appendChild($node); $newnode->setAttribute("name", $row['name']); $newnode->setAttribute("address", $row['adres']); $newnode->setAttribute("lat", $row['lat']); $newnode->setAttribute("lng", $row['lng']); // echo $row['name'], ' ', $row['address'], '
'; } echo $dom->saveXML(); ?>