Export XML with only one MySQL request ?
- by mere-teresa
I want to export in XML format some data from 7 tables (MySQL database), and then I want to import in another database.
And I have a update or insert rule for data.
I already have a SQL query retrieving all data, with JOINs on my 7 tables. But...when I try to put data in XML format, I reach a limit.
My PHP loop can catch each row, but I would like to benefit from hierachical structure of the XML, and all I have are rows with the same data repeated.
It is better to query once and to construct the XML tree in PHP or to query each time I want access to a lower level ?