*Combining* duplicates in an array

[apsoda]

Hello,

I have an array like this, created from a MySQL result set:

$items[] = array(  
    "item_id" => $item["ID_ITEM"],
    "item_count" => $itemfinal["BUNDLE"],
    // other values here
); 

There can be multiple rows with an identical $item_id and I'd like to create a new array with all the values intact, but with items of the same $item_id combined into one with a TOTAL of the $item_count.

Despite my efforts to figure it out, I'm afraid I'm stumped as to how to do that.

Thank you in advance for your help.

[Salathe]

Have you got an example of how the final array should look?

[apsoda]

Yes, sorry..

The original array would look like this:

[0] => Array
        (
            [0] => Array
                (
                    [item_id] => FIBC-0010-S-80X80X80
                    [item_bundle] => 0010
                    [item_description] => description
                    [item_price] => 19.00
                )

            [1] => Array
                (
                    [item_id] => FIBC-0010-S-80X80X80
                    [item_bundle] => 0010
                    [item_description] => description
                    [item_price] => 19.00
                )

            [2] => Array
                (
                    [item_id] => FIBC-0010-S-80X80X80
                    [item_bundle] => 0010
                    [item_description] => description
                    [item_price] => 19.00
                )

            [3] => Array
                (
                    [item_id] => FIBC-0010-S-90X90X90
                    [item_bundle] => 0010
                    [item_description] => description
                    [item_price] => 19.00
                )

        ) 

I'd like it to look like this:

[0] => Array
        (
            [0] => Array
                (
                    [item_id] => FIBC-0010-S-80X80X80
                    [item_bundle] => 0030
                    [item_description] => description
                    [item_price] => 19.00
                )

            [1] => Array
                (
                    [item_id] => FIBC-0010-S-90X90X90
                    [item_bundle] => 0010
                    [item_description] => description
                    [item_price] => 19.00
                )

        ) 

[StarLion]

This is easily accomplished with mySQL's GROUP BY clause and SUM function.

change your query to SELECT ... SUM(item_bundle)... FROM ... GROUP BY item_id ...

[apsoda]

Thank you, StarLion. However, I do need to keep the original array intact.

I was assuming I'd need to create a new array, either by extracting the information I need from the original, or by pulling the data from the database again and cross referencing it against the original.

[apsoda]

I have, in fact, been able to accomplish what I needed to by nesting MySQL queries based on StarLion's response.

Thank you very much

[Lemon Juice]

I was assuming I'd need to create a new array, either by extracting the information I need from the original, or by pulling the data from the database again and cross referencing it against the original.

If you want to do it in php then code like this should do it:

$newArray = array();  // here we will accumulate grouped data

foreach ($originalArray as $row) {  // loop through ungrouped data from db
  if (isset($newArray[$row['item_id']])) {
    // another occurence of this item_id
    $newArray[$row['item_id']]['item_count'] += $row['item_bundle'];
  } else {
    // first occurence of item_id
    $newArray[$row['item_id']] = array(
      'item_id' => $row['item_id'],
      'item_count' => $row['item_bundle'],
      'item_description' => $row['item_description'],
      'item_price' => $row['item_price'],
    );
} 

I assume that $originalArray contains elements of the top index 0 of your sample data, you will need to use $originalArray[0] with the structure you posted. The resulting $newArray will have item_id as keys, if you need a numerically indexed array just use array_values($newArray) at the end.