returning grouped data from MS SQL 7

[Anon]

I would like to know how to group my data by name of a person and the role they do. Because of the complex search query that I have I cannot use the group by in MS SQL Server 7.

here is an example of the data retrieved from the database

ID, Role, Cost
100 Tester 100
100 Developer 100
110 Tester 105

I would like to display only one row for ID=100 with either the second role for ID 100 on a the line below or concatenated with the first role. I would like to do this for persons with more than one role.

I have tried using mssql_fetch_array and mssql_fetch_row to do this without success

any suggestions would be greatly appreciated.