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 21:24

Your example doesn't produce the desired the results!

The reason I posted to the PHP list was I thought I would have to apply
some ARRAY functions to produce the output I'm looking for. Your
example did nothing more than mine produced.


On Thu, 2005-03-24 at 12:48 -0600, Jay Blanchard wrote:
> [snip]
> I'm trying to figure out the best way to handle a SELECT from multiple
> tables where a single ID in tableA relates to multiple ID's in tableB:
>
> "SELECT tableA.ID, tableB.data FROM tableA, tableB WHERE tableA.ID=3 AND
> tableA.ID=tableB.tableAID"
>
> What I'm trying to product is an array output similar to:
>
> | ID | data |
> | 3 | data1, data2, data3 |
> [/snip]
>
> SELECT a.foo, b.foobar
> FROM tableA a LEFT OUTER JOIN tableB b
> ON(a.id = b.id)
>
> SELECT p.users
> FROM php.list p LEFT OUTER JOIN mysql.list m
> ON (p.phpuserid = m.mysqluserid)
> GROUP BY p.users
> HAVING clue > 0;

 

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

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