How to sort an Array of Associative Arrays by a Value

Question

So I have an array:

$array = (
    array('name' => 'John' , 'total' => '33'),
    array('name' => 'Robert' , 'total' =>  '66'),
    array('name' => 'John' , 'total' => '22'),
)

I want to sort the arrays by the total.

So the output would be:

$array = (
    array('name' => 'Robert' , 'total' =>  '66')
    array('name' => 'John ' , 'total' => '33')
    array('name' => 'John' , 'total' => '22')
)

How can I do this?

Read http://www.php.net/manual/en/function.array-multisort.php — Anigel, May 16 '13 at 07:42

score 1 · Answer 1 · answered May 16 '13 at 07:46

1

Use Multisort for this

$total = array();
foreach ($array as $key => $row)
{
    $total[$key] = $row['total'];
}
array_multisort($total, SORT_DESC, $array);

answered May 16 '13 at 07:46

chandresh_cool

11,753
3
30
45

score 1 · Accepted Answer · answered May 16 '13 at 07:53

1

use array_multisort method

$arr = array(
    array('name' => 'John' , 'total' => '33'),
    array('name' => 'Robert' , 'total' =>  '66'),
    array('name' => 'John' , 'total' => '22'),
);

$total = array();
foreach ($arr as $key => $row)
{
    $total[$key] = $row['total'];
}
array_multisort($total, SORT_DESC, $arr);

answered May 16 '13 at 07:53

Waqar Alamgir

9,828
4
30
36

This is what i did and it worked for me. – user2385273 May 16 '13 at 09:59

score 0 · Answer 3 · answered May 16 '13 at 07:42

0

No, I think you should better use arsort(). http://www.php.net/manual/en/function.arsort.php

answered May 16 '13 at 07:42

Matheno

4,112
6
36
53

score 0 · Answer 4 · edited May 23 '17 at 12:17

0

function totalDescSort($item1, $item2)
{
    if ($item1['total'] == $item2['total']) return 0;
    return ($item1['total'] < $item2['total']) ? 1 : -1;
}
usort($array,'totalDescSort');

From here: https://stackoverflow.com/a/1597788/623400

edited May 23 '17 at 12:17

Community

1
1

answered May 16 '13 at 07:43

David Müller

5,291
2
29
33

Fabio · Answer 5 · 2013-05-16T07:55:35.860

I think you can use array_multisort() to order your array elements in a DESCENDING order:

$array = array(

     array('name' => 'John', 'total' => '33'),
     array('name' => 'Robert', 'total' =>  '66'),
     array('name' => 'John', 'total' => '22')

);

array_multisort($array, SORT_DESC);
var_dump($array);

this will output

array(3) {
  [0]=>
  array(2) {
    ["name"]=>
    string(6) "Robert"
    ["total"]=>
    string(2) "66"
  }
  [1]=>
  array(2) {
    ["name"]=>
    string(4) "John"
    ["total"]=>
    string(2) "33"
  }
  [2]=>
  array(2) {
    ["name"]=>
    string(4) "John"
    ["total"]=>
    string(2) "22"
  }
}

DEMO

How to sort an Array of Associative Arrays by a Value

5 Answers5