[thelist] [PHP] Converting a mulitdimentional array to a valid XML

Tris beertastic at gmail.com
Fri May 9 06:02:22 CDT 2008

No prob...
there's a client table(which I forgot to include..)
id, name and logo

each project is asigned to a client. (clientId)
Each image is asigned to a project in the 'work' table..

I only need the logo from the clients table, which is referenced from
the clientId in 'work'

So my total query get's a single work project, the relating client
logo, and all related images, from the images table...

Phew.. I think that's it...! ;-p

2008/5/9 r937 <rudy at r937.com>:
>> http://www.net-tastic.com/brand/xml.php
>> Firstly (~Rudy ;-p ) is there a way to get all this data in an array,
>> from a single MySQL query?
> there might be, if you could explain how the tables are related
> ;o)
> --
> * * Please support the community that supports you.  * *
> http://evolt.org/help_support_evolt/
> For unsubscribe and other options, including the Tip Harvester
> and archives of thelist go to: http://lists.evolt.org
> Workers of the Web, evolt !

"The only people who don't make mistakes are those who don't do anything"

Give a man a fish and he'll feed himself for a day.
Give a man a religion and he'll starve to death praying for a fish.

`We are what we pretend to be, so we must be careful what we pretend to be.`
Kurt Vonnegut

`When a person can no longer laugh at himself, it is time for others
to laugh at him.`
Thomas Szasz

More information about the thelist mailing list