Removing duplicates and adding up their values in multidimentional arrays

[bachx]

I'm looking for a way to remove duplicate values from the following example and add up their sum in a way like this:

 

Array
(
    [0] => Array
        (
            [name] => CAR
            [amount] => 1000
        )

    [1] => Array
        (
            [name] => BUS
            [amount] => 500
        )

    [2] => Array
        (
            [name] => CAR
            [amount] => 750
        )

)

 

To:

 

Array
(
    [0] => Array
        (
            [name] => CAR
            [amount] => 1750
        )

    [1] => Array
        (
            [name] => BUS
            [amount] => 500
        )


)

 

Any ideas? Thanks.

 

 

[ignace]

Possibly you got this from a db and IMO it would then be better to handle this in your query:

 

SELECT name, sum(amount) sum_amount FROM table GROUP BY name

[methomps]

<?php
$array1 = array(array('name'=>'CAR', 'amount'=>1000), array('name'=>'BUS', 'amount'=>500), array('name'=>'CAR', 'amount'=>750));

$array2 = array();

foreach($array1 as $miniarray)
{
if(isset($array2[$miniarray['name']]))
{
	$array2[$miniarray['name']] += $miniarray['amount'];
}	
else
{
	$array2[$miniarray['name']] = $miniarray['amount'];
}
}

//if it has to be in the format you specified
$array1 = array();
foreach($array2 as $key=>$value)
{
$array1[] = array($key=>$value);
}

?>

[methomps]

Correction, the last part of that should be:

 

//if it has to be in the format you specified
$array1 = array();
foreach($array2 as $key=>$value)
{
   $array1[] = array('name'=> $key, 'amount'=> $value);
}