Re: About One To Many MYSQL TO XML WITH PHP

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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 <ceo@xxxxxxxxx> 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



[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux