You are here: RE: [PHP] collapse SELECT from multiple tables « PHP « IT news, forums, messages
RE: [PHP] collapse SELECT from multiple tables

Posted by David Christensen on 03/24/05 23:16

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@connect4less.com>
> 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.
>

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация