Sort an array based on a specific column

Question

I have an array that outputs data that looks like this:

 [STU-CZC0226PVC] => Array
    (
        [ComputerName] => STU-CZC0226PVC
        [time_in_days] => 13
        [room] => 1N10
    )

[STU-FMDXZDHJF-M] => Array
    (
        [ComputerName] => STU-FMDXZDHJF-M
        [time_in_days] => 13
        [room] => 2R022
    )

[STU-CZC03184CM] => Array
    (
        [ComputerName] => STU-CZC03184CM
        [time_in_days] => 13
        [room] => 2Q11
    )

[STU-CZC0226PTM] => Array
    (
        [ComputerName] => STU-CZC0226PTM
        [time_in_days] => 13
        [room] => 1N10
    )

[STU-CZC12632SN] => Array
    (
        [ComputerName] => STU-CZC12632SN
        [time_in_days] => 13
        [room] => 1N75

I would like to sort the array so that the records with the same room number are listed together, but don't have a clue how to do it. I think it might use usort(), but I can't work out how to implement that, and was wondering if anyone could help?

Thanks

Possible duplicate of [Sort Array of MultiDiminsional Arrays on More Than One “Column” (Key) With Specified Sort Options](http://stackoverflow.com/questions/809771/sort-array-of-multidiminsional-arrays-on-more-than-one-column-key-with-speci?rq=1) — Gildas Ross, Mar 26 '14 at 14:54

score 0 · Answer 1 · answered Mar 26 '14 at 19:29

0

PHP >= 5.5.0

array_multisort(array_column($array, 'room', 'ComputerName'), SORT_DESC, $array);

PHP < 5.5.0

foreach($array as $key => $val) {
    $rooms[$key] = $val['room'];
}
array_multisort($rooms, SORT_DESC, $array);

answered Mar 26 '14 at 19:29

AbraCadaver

78,200
7
66
87

score 0 · Answer 2 · answered Mar 26 '14 at 19:32

0

You can use uasort in combination with strcmp:

uasort($array, function ($a, $b) {
    return strcmp($a['room'], $b['room']);
});

answered Mar 26 '14 at 19:32

TimWolla

31,849
8
63
96

Sort an array based on a specific column

2 Answers2