[thelist] [PHP] Converting a mulitdimentional array to a valid
Tris
beertastic at gmail.com
Fri May 9 07:54:38 CDT 2008
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
More information about the thelist
mailing list