Re: is this possible in one query?

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

 



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.

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux