sort by date value using php

Question

I am fetching dates from db to display the dates on the dropdown menu. It is displaying based on id.I want to sort the data based on dates.I am now getting dates in the below order:

  Saturday, March 25
  Saturday, April 15
  Wednesday, April 5
  Saturday, May 6
  Saturday, April 29
  Wednesday, May 10
  Saturday, May 20

i need the data in below order:

  Saturday, March 25
  Wednesday, April 5
  Saturday, April 15
  Saturday, April 29
  Saturday, May 6
  Wednesday, May 10
  Saturday, May 20

the code

   $dates = \Drupal::service('custom_forms.custom_forms_service')->getDates();
   $datesObj = array("" =>"- Select -");
   foreach($dates as $date){
        $datesObj[$date->id] = $date->date;
    echo "<pre>";print_r($datesObj[$date->id]);
     }
     exit;

Can you share your current query? Also, what [tag:rdbms] is this? [tag:mysql]? — Mureinik, Feb 28 '17 at 06:57
see this post:http://stackoverflow.com/questions/5080375/order-by-date-varchar — Suchit kumar, Feb 28 '17 at 07:03

score 0 · Answer 1 · edited May 23 '17 at 12:25

0

SELECT id, name, form_id, DATE(updated_at) as date
  FROM wp_frm_items
  WHERE user_id = 11 && form_id=9
  ORDER BY updated_at DESC,id ASC

This will sort the records by date first, then by names More detail

edited May 23 '17 at 12:25

Community

1
1

answered Feb 28 '17 at 07:04

Rahul Prajapati

426
1
4
12

i am given the data type for date as varchar. – Feb 28 '17 at 07:10
check this [link](https://api.drupal.org/api/drupal/includes!database!select.inc/function/SelectQuery%3A%3AorderBy/7.x) – Rahul Prajapati Feb 28 '17 at 07:12

sort by date value using php

1 Answers1