CODEWITHSUNDEEP
phparrayssortingmultidimensional-array
GoodSp33d
GoodSp33d

Reputation: 6292

Sort a multidimensional array by a column value

How can I sort a 2D array in PHP. I want to sort on date, Array is in this format : 

[result] => Array
        (
            [0] => Array
                (
                    [link] => http://local/node/0
                    [date] => 13158505310
                )

            [1] => Array
                (
                    [link] => http://local/node/1
                    [date] => 13158505311
                )

            [2] => Array
                (
                    [link] => http://local/node/2
                    [date] => 13158505312

Upvotes: 0

Views: 183

Answers (5)

Pankit Mehta
Pankit Mehta

Reputation: 11

may be this code helpful to you....

 // Obtain a list of columns
foreach (data as key => row) {
    links[key]  = row['link'];
    dates[key] = row['date'];
}

// Sort the data with link descending, date ascending
// Add $data as the last parameter, to sort by the common key
array_multisort(link, SORT_DESC, date, SORT_ASC, data);

Upvotes: 0

Aurimas Ličkus
Aurimas Ličkus

Reputation: 10074

Use this

 function sortByDateDesc($a, $b) {
   return strcmp($a["date"], $b["date"]);
 }

 function sortByDateAsc($a, $b) {

    if ($a['date'] == $b['date']) {
        return 0;
    }
    return ($a['date'] > $b['date']) ? -1 : 1;  
 }

 usort($array, 'sortByDateDesc'); //Descending order
 //usort($array, 'sortByDateAsc'); //Asceding order

Upvotes: 1

Engineer
Engineer

Reputation: 48813

Use usort:

usort( $array, function( $a, $b ){   return $a["date"] - $b["date"];  } );

Upvotes: 3

cyph3r
cyph3r

Reputation: 373

You could also try multisort http://www.php.net/manual/en/function.array-multisort.php

Upvotes: 0

Nanne
Nanne

Reputation: 64439

Use http://nl.php.net/manual/en/function.usort.php

Upvotes: 0

Related Questions