PHP - MYSQL - XML ( 2 Mysql Tables to 1 XML File ) How?

[behzad]

Hi there guys 

 

Stock again.  ???

 

I need to create a XML file from to related table from Mysql.

 

I have a shopping cart where I like to out put the cart into XML.

 

Table one is the invoice details like ( Invoice Number, Total, Clients detail, the usual )

 

Table 2 has products that are purchased with their details which has the reference in each row same as the reference in table one for relation.

 

How could I or how should I construct the XML File so it could be retrieved back in the future.

 

Each XML file for each invoice is an individual file with the invoice number as file name.

 

Please help.

 

B.E-N