How to sort array in PHP using one of the field

Question

I'm trying to sort the array in PHP. Please see my array:

Array
(
    [0] => Array
        (
            [id] => 8
            [date_start_month_name] => January
            [approved] => Accepted: yes
        )

    [1] => Array
        (
            [id] => 3
            [date_start_month_name] => January
            [approved] => Accepted: yes
        )

    [2] => Array
        (
            [id] => 2
            [date_start_month_name] => March
            [approved] => Accepted: yes
        )

    [3] => Array
        (
            [id] => 5
            [date_start_month_name] => April
            [approved] => Accepted: yes
        )

)

I want to sort the array using month name, for example: January and get something like this:

Array
(
    [0] => Array
        (
            [id] => 8
            [date_start_month_name] => January
            [approved] => Accepted: yes
        )

    [1] => Array
        (
            [id] => 3
            [date_start_month_name] => January
            [approved] => Accepted: yes
        )
)

How can I do that? Thanks in advance for any help. Best!

This question has been asked so many times it's not even funny... — Niet the Dark Absol, Feb 06 '13 at 09:57
$newarray = array(); foreach($mainarray as $v){ $newarray[$v['date_start_month_name']][] = $v; } — , Feb 06 '13 at 10:01
Do you want to "sort" or do you want to "filter"? It seems you mean you only want "month=January", not "sort by month". — Passerby, Feb 06 '13 at 10:01
use `mysql` `order by` to get the sorted result instead of sorting array in `php` — Suhel Meman, Feb 06 '13 at 10:01
@Passerby - yes, filter only using for example month=January or month=March — Jakub, Feb 06 '13 at 10:03
@Jakub Well since the question has been closed, checkout [this document](http://www.php.net/manual/en/function.array-filter.php). — Passerby, Feb 06 '13 at 10:08
@Passerby I already did that, but I'm still having some problems to FILTER my array :( — Jakub, Feb 06 '13 at 10:11
And it's funny when people saying DUPLICATE - CLOSE IT or something - the whole internet is a duplicate... :-] — Jakub, Feb 06 '13 at 10:12
@Jakub Then ask another question with a proper name, and do remember to attach your code. — Passerby, Feb 06 '13 at 10:13

jasir · Answer 1 · 2013-02-17T20:34:24.340

0

use usort

usort($array, function($a, $b) {
    return $a['date_start_month_name'] > $b['date_start_month_name']
});

edited Feb 17 '13 at 20:34

answered Feb 06 '13 at 09:59

jasir

1,473
11
28

score 0 · Answer 2 · answered Feb 06 '13 at 09:59

You can use the usort function to acheive this like so:

<?php
     // Sort the multidimensional array
     usort($results, "custom_sort");
     // Define the custom sort function
     function custom_sort($a,$b) {
          return $a['some_sub_var']>$b['some_sub_var'];
     }
?>

How to sort array in PHP using one of the field

2 Answers2

Linked

Related