Re: About One To Many MYSQL TO XML WITH PHP

I presume from your heading you want the XML file to contain a single occurrence from the ONE table and several occurrences from the MANY table? In that case you DO NOT want to use a join, instead you access the ONE table and the MANY table separately, as shown in http://www.tonymarston.net/php-mysql/dom.html#a4 -- Tony Marston http://www.tonymarston.net http://www.radicore.org "Kelvin Park" <kelvinpark86@gmail.com> wrote in message news:46A67358.1000807@gmail.com... >I am keep running in to a dead end with trying to convert mysql databse > tables (more than 4) to XML with PHP. Initially I tried to convert two > tables with the code that's attached to this email, however it's limited > to printing out just a table row "WHERE column='value'". I can relate > two tables on database with two rows that share same relational data, so > I can do that for one row. Do you know any website that might explain > how to convert joined multiple tables(with every rows) to XML? >