is this possible in one query?
| From: | Sjef Janssen | Date: | Sat, 14 Jan 2006 15:28:13 +0000 |
| Subject: | is this possible in one query? | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-41038@lists.php.net to get a copy of this message | ||
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!!