I'm working on an integration between a Flash Gallery (which use XML to present photos and data) and an PHP Admin Panel (which saves the data in a MySQL database). 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" subtitle="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 tags and attributes? I'm using your class.mysql_xml PHP Class (http://www.phpclasses.org/browse/package/782.html), but the exported XML is the following: <?xml version='1.0' encoding='UTF-8'?> <table> <ROW> <ID>26</ID> <CODE>1234567890</CODE> <COLLECTION>1</COLLECTION> <PRODUCT_NAME>test</PRODUCT_NAME> <CAPTION>test</CAPTION> <SUBTITLE>TEST</SUBTITLE> <PRICE>100</PRICE> <STATUS>1</STATUS> </ROW> </table> ------------------------ Yahoo! Groups Sponsor --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/KIlPFB/vlQLAA/TtwFAA/saFolB/TM --------------------------------------------------------------------~-> PHP Data object relational mapping generator - http://www.meta-language.net/ Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/php-objects/ <*> To unsubscribe from this group, send an email to: php-objects-unsubscribe@xxxxxxxxxxxxxxx <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
