Find highest value in multidimensional array [duplicate]

Question

The Problem

I have a multidimensional array similar to the one below. What I'm trying to achieve is a way to find and retrieve from the array the one with the highest "Total" value, now I know there's a function called max but that doesn't work with a multidimensional array like this.

What I've thought about doing is creating a foreach loop and building a new array with only the totals, then using max to find the max value, which would work, the only issue would then be retrieving the rest of the data which relates to that max value. I'm not sure that's the most efficient way either.

Any ideas?

Array (     [0] => Array         (             [Key1] => Key1             [Total] => 13         )      [1] => Array         (             [Key2] => Key2             [Total] => 117         )      [2] => Array         (             [Key3] => Key3             [Total] => 39         ) ) 

Answer 1

Just do a simple loop and compare values or use array_reduce

$data = array_reduce($data, function ($a, $b) {     return @$a['Total'] > $b['Total'] ? $a : $b ; });  print_r($data); 

See Live Demo

Answer 2

Since PHP 5.5 you can use array_column to get an array of values for specific key, and max it.

max(array_column($array, 'Total'))