xml file generation

I need to created XML file form query. Database is mysql and php is creating the file.

I wrote the code that loop through each row and each column and create and write all tags/data.

Is there more professional way to doing this?

Well all depends on what version of php our running.

There are some good XML parsing functions built into php5.

In PHP4 - you could use the PEAR XML_Serializer class.

Which converts arrays into XML and vice versa - so you could get your recordset as an array and pop it through the serializer.

Example from php.net/dom

http://us4.php.net/dom

I have PHP5

Cool - use SimpleXML