$xmlDom = new DOMDocument(); $xmlDom->appendChild($xmlDom->createElement('results')); $xmlRoot = $xmlDom->documentElement; while ( $row = mysql_fetch_row($result) ) { $xmlRowElementNode = $xmlDom->createElement('row'); $i=0; for($i=0;$i<mysql_num_fields($result);$i++) { $xmlRowElement = $xmlDom->createElement(mysql_field_name($result,$i)); $xmlText = $xmlDom->createTextNode($row[$i]); $xmlRowElement->appendChild($xmlText); $xmlRowElementNode->appendChild($xmlRowElement); } $xmlRoot->appendChild($xmlRowElementNode); } header('Content-type: text/xml'); echo $xmlDom->saveXML();