Hi, Untested but it would be something like this:
<?php header("Content-Type: application/xml"); //query database records $connection = mysql_connect("localhost", "user", "pass") or die("can't connect"); mysql_select_db("webbish"); $query = "SELECT id, title, artist FROM xmldb"; $result = mysql_query($query); if(mysql_num_rows($result) > 0){ //Create DomDocument ob_start(); echo '<?xml version="1.0" encoding="iso-8859-1"?><cds/>'; $buffer = ob_get_contents(); ob_end_clean(); $doc = domxml_open_mem($buffer); //Get root node $root = $doc->document_element(); //Iterate through result set while(list($id, $title, $artist) = mysql_fetch_row($result)){ //create item node $record = $root->new_child("cd", ""); $record->set_attribute("id", $id); //Attach title and artist as children of item node $record->new_child("title", $title); $record->new_child("artist", $artist); } echo $doc->dumpmem(); } ?> -- regards, Tom -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php