have you been able to get it to work w/ a select from just 1 table ? if thats the case then you are prolby getting hung up thinking about it being 4 tables. you should get the system going for just 1 table. once you have that try it for the joined query; the php to process the result set and build the xml should be the same in both cases, except there will likely be more columns in the latter query.
-nathan On 7/24/07, Richard Lynch <[EMAIL PROTECTED]> wrote:
On Tue, July 24, 2007 4:47 pm, Kelvin Park wrote: > 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? Seems to me you could create a "view" in SQL with whatever you want, and then dump it to XML as one big fat table... -- Some people have a "gift" link here. Know what I want? I want you to buy a CD from some indie artist. http://cdbaby.com/browse/from/lynch Yeah, I get a buck. So? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
