prepare("SELECT ID,Name FROM trips WHERE FK_Users_ID=? ORDER BY ID DESC"); $query->bind_param('i', $userid); $query->execute(); $query->bind_result($trackid,$trackname); header("Content-type: text/xml"); $xml = new XMLWriter(); $xml->openURI("php://output"); $xml->startDocument("1.0"); $xml->setIndent(true); $xml->startElement('root'); while ($query->fetch()) { $xml->startElement("trip"); $xml->writeElement("trackid", $trackid); $xml->writeElement("trackname", $trackname); $xml->endElement(); } $xml->endElement(); $xml->endDocument(); $xml->flush(); $query->free_result(); } $mysqli->close(); ?>