customize output with group by?

[tragikx]

i'm trying to have a query result displayed in like groups...for example, if i wanted to show a grouping of colors, and whos favorite color each color was...it would look like this:

Blue
1. Bob
2. Sam

Green
1. Mike
2. James

etc...
i come from a CFM background, and it was easy to do (i'll use the syntax for anyone with CF experience that can help)..

<cfoutput query=name group=color>
#color#
<cfoutput>
#name.currentrow#. #first_name#<br>
</cfoutput>
</cfoutput>

now using what i know of php, all i can do is this:
1. Bob - Blue
2. Sam - Blue
3. Mike - Green
4. James - Green

any light you can shed on this would be much appreciated =)

[mrhappiness]

$old_color = 'peanut butter';
while ($row = mysql_fetch_assoc($result)) {
  if ($old_color != $row['color']) {
    $old_color = $row['color'];
    echo '<h1>'.$old_color.'</h1>';
  }
  echo $row['username'].'<br />';
}

[tragikx]

thanks for the reply.

when i try your example, i get an output like this:

$old_color = 'blue';

Bob
Sam
Blue
Mike
James

any ideas?

[edit]
just changed
echo '<h1>'.$old_color.'</h1>';
to
echo '<h1>'.$row['color'].'</h1>';
and it worked like a charm, thanks!