Re: is this possible in one query?
| From: | Christoph Kunze | Date: | Wed, 18 Jan 2006 10:21:52 +0000 |
| Subject: | Re: is this possible in one query? | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-41068@lists.php.net to get a copy of this message | ||
Sjef Janssen schrieb:
Hi there, I have a table that keeps names for different language codes. In a short example: nameId name languageCode 31 House EN 31 Wohnung DE 32 Piece En 32 Stuck De 33 Car EN 33 PKW DE What I would like is to have a query that returns for example: nameId = 31 Names = House - Wohnung Maybe I can even have a result that consists of an array with nameIds and Names. Or should I fire a bunch of queries after each other to have this result? I use mysql and php 4.3.8 Tnxs!!SELECT nameId, GROUP_CONCAT(name SEPARATOR ' - ') AS names FROM table GROUP BY nameId I think that will do it.