How to join multiple rows as a row

[dbosz]

I have a table (as seen on below) from database name Security

Level Name
2 Matt
3 John
3 Tom
2 Sarah
1 Doe
1 Jack

My question is, how to get result and display (for display only not need to insert to db) like this:

Level Name
1 Doe Jack
2 Matt Sarah
3 John Tom

As far as I know, i can use "GROUP BY", but this method will only return the first row. I want to display it in html table , mean using row by row.

So, anybody have solution to my problem? Please help me.
Thank You.

[bogu]

This the first idea that I have in mind if I will have another idea I'll post you:
$str='';

while($sc=mysql_fetch_assoc(mysql_query(SELECT DISTINCT nr FROM table ORDER by nr ASC)))
        while($sc1=mysql_fetch_assoc(mysql_query(SELECT name FROM table WHERE nr=$sc['nr'])))
                $str.=$sc1['name'].' ';
        echo $sc['nr'].' '.$str;

Hope this is what you have in mind.

[bogu]

Or you can do like this:

SELECT DISTINCT nr,name FROM `level` GROUP BY name ORDER BY nr ASC

[dbosz]

how about i want to put another column