Sort months array by position

Question

I need to sort an array of months (alphabetical months) according to their months position and not alphabetical. My script returns a list of events and builds an multi-associative arrays based on years => months e.g. 2012 => array("August","March","September"), 2013 => array("April","May"); It builds the array perfectly, but I now need to sort the months so that it would return 2012 => array("March","August","September"), 2013 => ("April","May);

Here is the script I am currently using. Note that the date field in mysql is set to DATE and not VARCHAR, and dates are entered YYYY-MM-DD

public function returnMonthsArray() {
        $sql = "SELECT `date` FROM `events` WHERE `status`=1 ORDER BY `name`";
        $results = $this->db->returnMultiAssoc($sql);
        $navArray = array();
        foreach($results as $key => $value) {
            $timestamp = strtotime($value["date"]);
            $year = date("Y",$timestamp);
            $month = date("F",$timestamp);
            if(!array_key_exists($year, $navArray)) {
                $navArray[$year] = array();
            }
            if(!in_array($month,$navArray[$year])) {
                $navArray[$year][] = $month;
            }
        }
        if(count($navArray)) {
            return $navArray;
        } else {
            return false;
        }
    }

Use this query: SELECT `date` FROM `events` WHERE `status`=1 ORDER BY MONTH(`data`), `name` ? — meze, Mar 05 '12 at 08:25
Ideally this should be done by adding an ORDER BY clause in your query. — Salman A, Mar 05 '12 at 08:28
Excellent Meze! Your query update saved the day. Make an answer and he's confirm it as the correct answer — mauzilla, Mar 07 '12 at 14:01

score 1 · Answer 1 · edited May 23 '17 at 11:55

1

Have a look to this post:

PHP and Enums

By specifing an enum like behavior for the months it would be easier to sort them the way that you want.

I hopw that this is helpful to you.

edited May 23 '17 at 11:55

Community

1
1

answered Mar 05 '12 at 08:25

Aristotelis Kostopoulos

835
4
15

score 1 · Accepted Answer · answered Mar 05 '12 at 08:41

1

try this query

SELECT `date` FROM `events`
WHERE `status`=1 ORDER BY `name`"
GROUP BY MONTH(`date`)

answered Mar 05 '12 at 08:41

Naveen Kumar

4,543
1
18
36

Sort months array by position

2 Answers2