Sort rows of a 2d array by column value [duplicate]

Question

I have an array like this:

Array
(
    [0] => Array
        (
            [title] => some title
            [time] => 1279231500
        )

    [1] => Array
        (
            [title] => some title 2
            [time] => 1279231440
        )
    
    [2] => Array
        (
            [title] => some title 3
            [time] => 1279229880
        )
)

How I can sort it based on time?

Peter Ajtai · Accepted Answer · 2010-08-29 18:46:38Z

4

You can sort it this way (since it is an associative array):

function cmp($a, $b)
{
   return strcmp($a['time'], $b['time']);
}

usort($your_array, "cmp");
print_r($your_array);

edited Aug 29, 2010 at 18:46

Peter Ajtai

57.8k13 gold badges124 silver badges143 bronze badges

answered Aug 29, 2010 at 18:24

Sarfraz

384k81 gold badges561 silver badges613 bronze badges

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

4 Comments

greenbandit Over a year ago

any idea how to reverse the order?

Peter Ajtai Over a year ago

@greenbandit - Change the comparison function to return strcmp($b['time'], $a['time']); - usort() is sorting based on cmp().

NikiC Over a year ago

@reverse: Either return -1 * strcmp(...); or apply array_reverse after sort.

Gumbo Over a year ago

You should not use strcmp for integer values. Because 2 < 12 but strcmp(2, 12) === 1 that means “2 is greater than 12”.

Simon · Accepted Answer · 2012-01-20 10:24:43Z

1

As Gumbo mentioned, you should not use strcmp for integer values.

Use this function

function cmp($a, $b) {
    if ($a['time'] == $b['time'])
        return 0;
    return ($a['time'] < $b['time']) ? -1 : 1;
}

edited Jan 20, 2012 at 10:24

answered Jan 19, 2012 at 11:33

Simon

23.2k36 gold badges95 silver badges123 bronze badges

1 Comment

salathe Over a year ago

For integer values, return $a['time'] - $b['time']; would suffice.

Collectives™ on Stack Overflow

Sort rows of a 2d array by column value [duplicate]

2 Answers 2

4 Comments

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

1 Comment

Linked

Related