Menu
Community /Pin to ProfileBookmark
@NogDogJan 19.2022 — #Not necessarily better, just more fun (I mean, come on: it uses the "spaceship" operator :) ):
@NogDogJan 24.2022 — #Maybe...
Or, use my
Or, if that data is coming from a DB query, add a sort on that column in the SQL so that the highest will always be first (or last if you prefer). This would probably be the most efficient solution if it would be applicable.
Max value from multi multidimensional with keys
Hello. I have simple multi array.
`$cities = array(
0 => array(
‘City’ => ‘Los Angeles’,
‘Salary’ => ‘5000’
),
1 => array(
‘City’ => ‘Tampa’,
‘Salary’ => ‘9600’
),
2 => array(
‘City’ => ‘Sanford’,
‘Salary’ => ‘4500’
),
);
`
I know how to get the maximum salary.
`$max = ”;
foreach($cities as $key => $value) {
$make_array[] = $value[‘Salary’];
$max = max($make_array);
}
echo $max;
`
But how do we get the maximum salary and take the city?
For example:
Salary: 9600
City: Tampa
Sign in
to post a comment11 Comments(s) ↴
0
@NogDogJan 19.2022 — #Not necessarily better, just more fun (I mean, come on: it uses the "spaceship" operator :) ):[code=php]
usort($cities, function($a, $b) {
return $b['Salary'] <=> $a['Salary'];
});
echo "Max city: {$cities[0]['City']}, salary: {$cities[0]['Salary']}n";0
@NogDogJan 24.2022 — #Maybe...[code=php]
// leave out the initialization of $last_sal, then...
foreach($cities as $k=>$v)
{
if(!isset($last_sal) or $v['Salary'] > $last_sal)
{
$max_ar = $v;
$last_sal = $v['Salary'];
}
}
[/code]Or, use my
usort()Or, if that data is coming from a DB query, add a sort on that column in the SQL so that the highest will always be first (or last if you prefer). This would probably be the most efficient solution if it would be applicable.