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

[Tris]

Nice one...
Now I've just gotta get that into XML..
You're are a clever man, and that's Virtual beer No 12 I think...



2008/5/9 r937 <rudy at r937.com>:
>> Each image is asigned to a project in the 'work' table..
>
> i guessed that this was parentId
>
>
> SELECT work.posterImage as poster_pic
>     , work.title
>     , FROM_UNIXTIME(work.date, '%d.%m.%y') as date
>     , work.blurb
>     , clients.img as client_logo
>     , work.media
>     , images.id
>     , images.imgType
>     , images.etc
>  FROM work
> INNER
>  JOIN clients
>    ON clients.id = work.clientId
> INNER
>  JOIN images
>    ON images.parentId = work.id
>  WHERE work.id = 1
>
> --
>
> * * 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.
Anon

`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