how to customize this ?

[PHPycho]

Hello forums !!
I am not getting the solution for the following case:
My query results gives the following results:

--------------------

| field1 | field 2 |

| name1 | value1 |
| name1 | value2 |
| name1 | value3 |
| name2 | value4 |
| name2 | value5 |
:
:

etc.

while($row = ..){
	//show results  here..
}

I would like to show the results as:

name1
-value1
-value2
-value3

name2
-value4
-value5

without displaying like

name1
-vaue1
name1
-value2
name1
-value3 etc..

Please help me in this case..
Thanks in advance to all of you

[cgraz]

SELECT field1, 
   GROUP_CONCAT(field2) AS field2
   FROM your_table 
GROUP 
   BY field1

will return this:

field1    field2
------    ------
name1     value1, value2, value3
name2     value4, value5

From there, use you could use str_replace() in your loop to replace the commas with a <br /> and a -

[bradgrafelman]

cgraz wrote:

From there, use you could use str_replace() in your loop to replace the commas with a <br /> and a -

Or you could even integrate that into your query:

SELECT field1, 
   GROUP_CONCAT(field2 SEPARATOR '<br/>-') AS field2
   FROM your_table 
GROUP 
   BY field1