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 — Gildas Ross
– Gildas Ross, Commented Mar 26, 2014 at 14:54

AbraCadaver · Accepted Answer · 2014-03-26 19:29:09Z

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, 2014 at 19:29

AbraCadaver

79.2k7 gold badges75 silver badges91 bronze badges

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

Comments

Community · Accepted Answer · 2023-11-17 19:32:19Z

0

You can use uasort in combination with strcmp:

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

edited Nov 17, 2023 at 19:32

CommunityBot

11 silver badge

answered Mar 26, 2014 at 19:32

TimWolla

32.9k8 gold badges67 silver badges97 bronze badges

Collectives™ on Stack Overflow

Sort an array based on a specific column

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related