Form a query

[orion_rus]

I need some help in a query
i have database where i need to find all inclusive words from table such this:
ids = word
1 concrete
1 metal
1 beton
2 seem
2 make
3 find

i need following database output
1 concrete,metal,beton
2 seem,make
3 find

how i can make this?

[Rebrandt]

Hi, if this is MySQL database then:

SELECT id, GROUP_CONCAT(word SEPARATOR ', ') AS words
FROM table
GROUP BY id

[orion_rus]

i have a mysql 4.0 and haven't group_concat, may be somebody have another way?

[coopster]

You won't be able to use subqueries either then. You'll have to loop and put them together yourself. Here is an example in PHP ...
[webmasterworld.com...]