Sorting a multidimensional array by column value [duplicate]

Question

I've an array like this

Array
(

[0] => Array

        (
            [result] => Array
                (
                    [0] => Array
                        (
                            [type] => ABC
                            [id] => 123232
                            [name] => Apple

                        )

                    [1] => Array
                        (
                            [type] => DEF
                            [id] => 2323232
                            [name] => Banana

                        )

                )


            [title] => Cool
            [rank] => 2
        )

  [1] => Array
        (
            [result] => Array
                (
                    [0] => Array
                        (
                            [type] => ZX
                            [id] => 3223
                            [name] => Danny

                        )

                    [1] => Array
                        (
                            [type] => QWER
                            [id] => 2323232
                            [name] => Cactus

                        )

                )


            [title] => Hot
            [rank] => 1
        )


[3]..
[4]..and son on

I would like to sort by rank, is there any quick sort method in PHP to do that?

alex · Accepted Answer · 2011-06-02 06:54:52Z

4

You could use usort().

The example below requires >= PHP 5.3. If you don't have this version, just pass a reference to the callback.

usort($array, function($a, $b) {
   return $a['rank'] - $b['rank'];
}

answered Jun 2, 2011 at 6:54

alex

492k205 gold badges890 silver badges992 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

codaddict · Accepted Answer · 2011-06-02 07:54:23Z

3

You can use the usort function:

function cmp($a, $b) {
    return $a['rank'] - $b['rank'];
}

$arr = /* your array */

usort($arr, "cmp");

See it

To sort on rank in descending order (question asked in comments), you just reverse the order in the compare function:

function cmp($a, $b) {
    return $b['rank'] - $a['rank'];
           ^^           ^^
}

edited Jun 2, 2011 at 7:54

answered Jun 2, 2011 at 6:55

codaddict

457k83 gold badges501 silver badges537 bronze badges

5 Comments

xkeshav Over a year ago

@codaddick; i really doesn't undestand how it works in all sorting methods $a -$b; would you please describe or give me a link to underatand

deceze Over a year ago

@diEcho The comparison function only needs to return 0 if both are equal, a value < 0 if the first element is lower and a value > 0 if the first element is higher than the second. Since the ranks are numeric $a - $b accomplishes this.

kapa Over a year ago

@diEcho If they are equal, 0 will be returned, if $a is smaller, a negative number will be returned, if $a is bigger, a positive number will be returned.

codaddict Over a year ago

@diEcho: The comparison function must return an integer less than, equal to, or greater than zero if the first argument is considered to be respectively less than, equal to, or greater than the second. One can use an else to achieve it but a simpler way is to do return $a - $b;

flyclassic Over a year ago

Thanks all for the super fast reply! wondering how to sort by descending for this case?

Raptor · Accepted Answer · 2011-06-02 06:54:31Z

0

There are multiple ways to sort an array, see : http://php.net/manual/en/array.sorting.php

answered Jun 2, 2011 at 6:54

Raptor

54.4k47 gold badges254 silver badges405 bronze badges

Collectives™ on Stack Overflow

Sorting a multidimensional array by column value [duplicate]

3 Answers 3

Comments

5 Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

5 Comments

Comments

Linked

Related