Grouping an array

MitchEvans

Hi Guys I have two sets of data in arrays like so

<?php
echo"$alllevels[$countbuildingnow] - $testarray[$countbuildingnow]<br>";
?>

That gives details like so:

Level 1 - 50
Level 2 - 30
Level 2 - 50
Level 2 - 70
Level 1 - 60

I would like them grouped so I need to show the data like so:

Level 1 - 110
Level 2 - 150

How would I do this?

Hope you can help thanks for looking 🙂

bpat1434

Really the easiest thing is going to be to create a new array and sum as you go. Something like:

$sums = array();
for($i=0;$i<count($alllevels); $i++)
{
    if(!array_key_exists($alllevels[$i], $sums))
        $sums[$alllevels[$i]] = 0;

$sums[$alllevels[$i]] += $testarray[$i];
}

print_r($sums);

Then you can loop through $sums and display it you please.

While that is a solution, the better is to take a look at how you originally construct the arrays and reconstruct it. Either sum it up as you go (like above) or add array elements to the key so your array looks like:

["Level 0"] => Array (
    [0] => 50,
    [1] => 60
),
["Level 1"] => Array (
    [0] => 30,
    [1] => 50,
    [2] => 70
)

With a setup like that you could easily do:

foreach($alllevels as $level => $values)
{
    echo $level.' - '.array_sum($values).'<br />';
}

Either way will work.

MitchEvans

Thats great thanks for your help!!! i'm using the first option and have this when I print r:

Array ( [Level 2] => 66.67 [Level 1] => 0 ) 
Array ( [Level 2] => 166.67 [Level 1] => 0 )  

Array ( [Level 2] => 255.56 [Level 1] => 0 ) 
Array ( [Level 2] => 255.56 [Level 1] => 100 )

so how do I loop through and get this:

Level 2 = 255.56
Level 1 = 100

Really appreciate the help here 🙂

bpat1434

You shouldn't need to. Something is going fishy... what's your code look like? Copy/paste your exact code 😉 Just because your code looks like mine, doesn't mean it works like mine 😉 Of course, I could have posted a bug as well 😉

MitchEvans

I think I have that code in a loop, outside the loop it looks like so:

Array ( [Level 2] => 255.56 [Level 1] => 100 )

Does this make more sense?!?

I just want to be able to echo each one like so

Level 2 - 255.56
Level 1 - 100

Thank you so mush for all your help 🙂

bpat1434

So you can do:

foreach($array as $level => $val)
    echo $level.' - '.$val.'<br />';