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; -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
