ansaurus

Question

Grouped/Stratified Reports using PHP and MySQL

Answer 1

+1 A:

while($row=mysql_fetch_array($result))
{
    $itemsByUser[$row['UserName']][] = $row;
}

foreach($itemsByUser as $user => $items)
{
    echo $user . "<br>";
    foreach($items as $array)
    {
        echo "-" . $array['ItemName'];
    }
}

This first creates an array that is order by Username. This means each user has an element in the array that contains an array of the items that have been assigned to the user.

Then, we go over each user and print out all of the items.

Chacha102 2010-02-07 03:53:20

Thanks, that worked perfectly!

Michael 2010-02-07 04:12:52

If it worked perfectly, you might want to click the green checkmark next to my answer to mark it as correct.

Chacha102 2010-02-07 04:18:33

How would you go about adding a second grouping level? Let's say Female Users and Male Users? (Females -> Username -> Items / Males -> Usernames -> Items)

Michael 2010-02-08 22:29:41

ansaurus

tags:

views:

answers:

Grouped/Stratified Reports using PHP and MySQL

related questions