Sort array using multiple criteria in PHP
arrays, multidimensional-array, php, sorting
Solution
Your function should be like this:
function order_by_score_endgame($a, $b) {
if ($a['score'] == $b['score']) {
// score is the same, sort by endgame
if ($a['endgame'] > $b['endgame']) {
return 1;
}
}
// sort the higher score first:
return $a['score'] < $b['score'] ? 1 : -1;
}
Try it out. It will give you result like this:
Array
(
[0] => Array
(
[uid] => 1
[score] => 9
[endgame] => 2
)
[1] => Array
(
[uid] => 2
[score] => 4
[endgame] => 1
)
[2] => Array
(
[uid] => 4
[score] => 4
[endgame] => 70
)
[3] => Array
(
[uid] => 3
[score] => 4
[endgame] => 100
)
)
Problem
I know there are some other topics about sorting with multiple criteria, but they don't fix my problem. Let's say I have this array: ``` Array ( [0] => Array ( [uid] => 1 [score] => 9 [endgame] => 2 ) [1] => Array ( [uid] => 2 [score] => 4 [endgame] => 1 ) [2] => Array ( [uid] => 3 [score] => 4 [endgame] => 100 ) [3] => Array ( [uid] => 4 [score] => 4 [endgame] => 70 ) ) ``` I want to sort it, putting the one with the HIGHEST score on top. On same score, I want the one with the LOWEST endgame number on top. The sorting mechanisme should rank user1 on top, then user2, then 4 and then user3. I use this sorting mechanisme: ``` function order_by_score_endgame($a, $b) { if ($a['score'] == $b['score']) { // score is the same, sort by endgame if ($a['endgame'] == $b['endgame']) return 0; return $a['endgame'] == 'y' ? -1 : 1; } // sort the higher score first: return $a['score'] < $b['score'] ? 1 : -1; } usort($dummy, "order_by_score_endgame"); ``` This gives me the following array: ``` Array ( [0] => Array ( [uid] => 1 [score] => 9 [endgame] => 2 ) [1] => Array ( [uid] => 3 [score] => 4 [endgame] => 100 ) [2] => Array ( [uid] => 2 [score] => 4 [endgame] => 1 ) [3] => Array ( [uid] => 4 [score] => 4 [endgame] => 70 ) ) ``` As you can see, the array isn't sorted properly... Anyone knows what I'm doing wrong? Thanks a lot!