Export table data to XML file

[Konstantinos Christodoulakis]

I have a mySQL table named "products" with the following columns:

`products` (
`id` int(11) NOT NULL auto_increment,
`code` int(11) NOT NULL default '0',
`collection` longtext NOT NULL,
`product_name` longtext NOT NULL,
`caption` longtext NOT NULL,
`subtitle` longtext NOT NULL,
`price` varchar(100) NOT NULL default '0',
`status` int(1) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=29 ;

How can I export some of the data to an XML file with the following structure, using php ? :

<?xml version="1.0" encoding="utf-8"?>
<collection name="xyz" description="xyz" status="xyz">
<image filename="pic1x.jpg" caption="xyz" />
etc
etc
etc
</collection>

I know I may use an Select SQL Query to select the data, but how can I map them to XML nodes and attributes?