Creating a report with group by ID

[jcjst21]

I have been searching the forums to find how to group a table by ID and list each record associated with it.

 

All I have been finding is how to group by and using it to do a sum or average or count.

 

What I want to do is,

 

Group By ID, and list each associated row...

 

Example:

 

Group A:

 

  -Person A

  -Person B

 

Group B

 

  -Person C

  -Person D

 

 

I tried multiple variations of a while loop without success...

 

any advice?

 

 

[ManiacDan]

You could use the group_concat function.

 

You could also simply order by the group ID, and only print it when it changes.

[jcjst21]

I'll try group concat

 

but also, how could i indicate when the groupID changes in the while loop?

 

 

[ManiacDan]

Keep $oldGroupName in a variable.  Check it with every iteration of the loop.

[jcjst21]

If i did it this way where it only prints if the group id changes then how can i make a header for the group name?

 

[Barand]

$prev = null;
while ( whatever ) {
    if ($current != $prev) {
        echo "Heading";
        $prev = $current;
    }
    echo "Details";
}