How to sort a multidimensional array by a certain key?

Question

This should be really simple, but what is the way to go on this. I want to sort an multidimensional array by a key, like this:

Array (
[0] => Array
    (
        [iid] => 1
        [invitee] => 174
        [nid] => 324343
        [showtime] => 2010-05-09 15:15:00
        [location] => 13
        [status] => 1
        [created] => 2010-05-09 15:05:00
        [updated] => 2010-05-09 16:24:00
    )

[1] => Array
    (
        [iid] => 1
        [invitee] => 220
        [nid] => 21232
        [showtime] => 2010-05-09 15:15:00
        [location] => 12
        [status] => 0
        [created] => 2010-05-10 18:11:00
        [updated] => 2010-05-10 18:11:00
    ))

Say i want to sort this by [status], how would I achieve this? Thanks in advance!

this has been asked lots of times - see stackoverflow.com/questions/777597/… , stackoverflow.com/questions/96759/… , stackoverflow.com/questions/96759/… for a start — John Carter
– John Carter, Commented May 10, 2010 at 17:12

Austin Fitzpatrick · Accepted Answer · 2010-05-10 17:08:33Z

7

//define a comparison function
function cmp($a, $b) {
    if ($a['status'] == $b['status']) {
        return 0;
    }
    return ($a['status'] < $b['status']) ? -1 : 1;
}

usort($array, "cmp");

That should do what you want, you can alter the comparison function to sort on whatever key you want.

answered May 10, 2010 at 17:08

Austin Fitzpatrick

7,3593 gold badges28 silver badges22 bronze badges

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

Comments

Prasanth Bendra · Accepted Answer · 2013-02-25 08:13:34Z

2

Try this : Using array_multisort

$sort = array();
foreach($your_array as $k=>$v) {
    $sort['status'][$k] = $v['status'];
}

array_multisort($sort['status'], SORT_DESC, $your_array);


echo "<pre>";
print_r($your_array);

Ref: http://php.net/manual/en/function.array-multisort.php

answered Feb 25, 2013 at 8:13

Prasanth Bendra

33.2k9 gold badges56 silver badges74 bronze badges

Comments

Tomasz Tybulewicz · Accepted Answer · 2010-05-10 17:06:01Z

1

usort function is what you're looking for:

<?php
    function cmp($a, $b) {
        return $b["status"] - $a["status"];
    }

    $sorted = usort($your_array, "cmp");
    var_dump($sorted);
?>

answered May 10, 2010 at 17:06

Tomasz Tybulewicz

8,6773 gold badges46 silver badges44 bronze badges

Comments

Mihai Toader · Accepted Answer · 2010-05-10 17:09:31Z

0

Try this

function cmp_by_status($a, $b)
{
    if ($a['status'] == $b['status']) {
        return 0;
    }
    return ($a['status'] < $b['status') ? -1 : 1;
}

usort($data_array, "cmp_by_status");

answered May 10, 2010 at 17:09

Mihai Toader

12.3k1 gold badge31 silver badges33 bronze badges

Comments

Community · Accepted Answer · 2017-05-23 12:34:07Z

0

I have added this answer at Sort multi-dimensional array by specific key sort the array specific key to sorting array value.

function sortBy($field, &$array, $direction = 'asc')
{
    usort($array, create_function('$a, $b', '
        $a = $a["' . $field . '"];
        $b = $b["' . $field . '"];

        if ($a == $b)
        {
            return 0;
        }

        return ($a ' . ($direction == 'desc' ? '>' : '<') .' $b) ? -1 : 1;
    '));

    return true;
}

Call this function by specific array key

sortBy('status',   $array);

edited May 23, 2017 at 12:34

CommunityBot

11 silver badge

answered Mar 2, 2016 at 13:24

Kishan Chauhan

1,2361 gold badge12 silver badges19 bronze badges

Collectives™ on Stack Overflow

How to sort a multidimensional array by a certain key?

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related