Help with one select query. :)

[bogu]

I have a table with 2 fields, lets say field1 and field2:

Now I have records in that table something like this:

1 a
1 ab
2 a

What I need is to make a selection and the result returned to be something like this:

1 a;ab
2 a

So, I want for the same field1 to concat field 2 using a separator (ex. ‘;’).

Mysql server version is 4.0

That for any help you can give.

[devinemke]

$result = mysql_query('SELECT * FROM table') or exit(mysql_error());
while ($row = mysql_fetch_assoc($result)) {$array[$row['field1']][] = $row['field2'];}
foreach ($array as $key => $value) {echo $key . ' ' . implode(';', $value);}