CODEWITHSUNDEEP
phparrayssortingmultidimensional-array
Eelke
Eelke

Reputation: 2327

How to sort a multidimensional array by a certain key?

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!

Upvotes: 5

Views: 8035

Answers (5)

Kishan Chauhan
Kishan Chauhan

Reputation: 1236

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);

Upvotes: 0

Prasanth Bendra
Prasanth Bendra

Reputation: 32840

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

Upvotes: 2

Mihai Toader
Mihai Toader

Reputation: 12253

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");

Upvotes: 0

Austin Fitzpatrick
Austin Fitzpatrick

Reputation: 7349

//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.

Upvotes: 7

Tomasz Tybulewicz
Tomasz Tybulewicz

Reputation: 8657

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);
?>

Upvotes: 1

Related Questions