RE: collapse SELECT from multiple tables

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

 



Thanks, I just use my original SQL and setup a foreach loop to compare
the 'ID' to see whether or not a record was returned with multiple row
results.

I was just hoping someone had all ready figured out some kool, neato,
voodoo-magic way to handle a one-to-many result like this.


On Thu, 2005-03-24 at 13:02 -0800, Chris W. Parker wrote:
> David Christensen <mailto:davidc@xxxxxxxxxxxxxxxx>
>     on Thursday, March 24, 2005 12:34 PM said:
> 
> > I don't know how to say it any plainer than that.
> > 
> > The original post would have produced the following:
> > 
> > 1, 'joe', 'part1'
> > 1, 'joe', 'part2'
> > 1, 'joe', 'part3'
> > 
> > but what I'd like to get is:
> > 1, 'joe', 'part1, part2, part3'
> 
> I think this is the explanation we needed.
> 
> Serious question: Is it that you want someone to write the loop for your
> do you just need some ideas?
> 
> > Thanks for your help.  I think I may have to redesign this thing to
> > make this easier or I maybe I just don't have the vocabulary to ask
> > the question correctly.
> 
> A redesign sounds good. Maybe instead of trying to make an oddly
> structured array you can instead adjust the code that receives the array
> to receive the unmodified array?
> 
> 
> Chris.
> 

-- 
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