Mysql to XML

Hi,

how to convert from mysql table to xml file? and if there is more than one table related to each other, how can i translate all of this to XML files to be used in Flash MX?

any ideas?

I don't know if this is gonna help, but if I had to do it, I'd probably start by dumping my tables to a structured format, like CSV, open the CSV in excel, then process it and save it as an XML file.

Then, write an XSL file that will translate the XML into HTML.

I don't know anything about flash, but assuming flash code is embedded into HTML somewhere, you'd place it into XSL instead..

How easy it's going to be depends on your knowledge on these various technologies. Ask me if you need details.

I'm actually doing some work in this area & I'm using PHP (or you could use ASP if you're in a microsoft house) to reformat mysql recordsets into whatever xml I want. I recall that flash has some functions you can use to make HTTP requests & XML requests while the app is still loaded. As far as various tables related together. Well that is what SQL is all about my friend. I'm sure if you use some joins you'll be good to go.