jag

i\'m stuck on a data output problem. i\'m accessing a mysql database and retrieving all the row data. there are 3 fields - UID, SID, Answer i\'m connecting and getting the data just fine. the problem is that there are multiple rows with the same UID and the data prints just like that. here\'s a sample: 83332091781424;2;felwick01 83332091781424;2;x 83332091781424;2;N1 83332091781424;2;N1 83332091781424;2;N1 83332091781424;2;N2 39808168103209171;2;felwick02 39808168103209171;2;x 39808168103209171;2;N2 39808168103209171;2;N1 39808168103209171;2;N4 39808168103209171;2;N6 what i need is only 1 instance of the UID, 1 instance of the SID, and then all the Answer field for each UID printed in a continuous row. example - 83332091781424;2;felwick01;x;N1;N1;N1;N2 39808168103209171;2;felwick02;x;N2;N1;N4;N6 any help would be *greatly* appreciated!