Re: About One To Many MYSQL TO XML WITH PHP
| From: | Richard Lynch | Date: | Wed, 25 Jul 2007 02:57:19 +0000 |
| Subject: | Re: About One To Many MYSQL TO XML WITH PHP | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-259468@lists.php.net to get a copy of this message | ||
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?