how to export a mysql table to XML?

[fatnjazzy]

hi
is there any function in PHP that lets u export a complete my sql table to xml?
i would be glad for a link, i have googled it .... no answers.
thanks

[lucasrd]

I just wrote a custom class to handle this...it basically takes any mysql query and outputs xml...this is the jist of it:

function xmlOut($sql){

  $xml = "<recordSet>\n"; 
  $result = mysql_query($sql);
   while($row = mysql_fetch_array($result)){
      $xml .= "<record>\n";

  while(list($key,$val) = each($row)){
         $xml .= "<field name='".$key."'>" . rawurlencode($val) . "</field>\n";
  } 
   $xml .= "</record>\n";
   }

   $xml .= "</recordSet>";

   return $xml;
}

I just wrote this off of the top of my head right now, so there's no guarantee it works as is...

With this function, exporting a whole table would entail passing a "select *" query to the function.

[fatnjazzy]

thanks mate for your help,
i will try it.
thanks again