Sorting multi-dimentional array

Question

I am trying to sort a multidimensional array based on 1 field so when I run a foreach loop to loop through it will be sorted in the right order...

I have tried several sources but found very few results on multi-dimensional array sorting...

When I run the loop on the below array it shows id field order as 1|2 i want it to be 2|1 what would be the best way to achieve this?

Basically just sort it in descending order...

Array:

array(2) {
    [0]=> array(1) {
        [0]=> array(4) {
            [0]=> string(1) "1" 
            ["id"]=> string(1) "1" 
            [1]=> string(0) "" 
            ["invoicenum"]=> string(0) "" 
        } 
    } 
    [1]=> array(1) { 
        [0]=> array(4) { 
            [0]=> string(1) "2" 
            ["id"]=> string(1) "2" 
            [1]=> string(0) "" 
            ["invoicenum"]=> string(0) "" 
        } 
    } 
}

@PrafullaKumarSahu No, I want to list it in a select box sorted... — Marcel, Feb 02 '16 at 14:49
How would the sorting work exactly? What kind of data structure can we expect? Is it always just one `[0]` index in the inner array? Or could there be more? How would it be sorted then? — deceze, Feb 02 '16 at 14:56
@deceze yes. It would remain in this structure, 1 main array and only single level child arrays that follow. — Marcel, Feb 02 '16 at 18:59
Then all you need to do is http://stackoverflow.com/a/17364128/476, with `$a[0][..]` in your comparison callback. — deceze, Feb 02 '16 at 19:08

score 0 · Answer 1 · answered Feb 02 '16 at 14:49

0

Have you try this?

array_multisort

<?php
// Obtain a list of columns
foreach ($data as $key => $row) {
    $mid[$key]  = $row['id'];
}

// Use $data to sort by the common key
array_multisort($mid, SORT_DESC, $data);
?>

answered Feb 02 '16 at 14:49

Lorenzo Belfanti

1,205
3
25
51

Sorting multi-dimentional array

1 Answers1