如何在codeigniter中按日期降序排序

Question

I want to show timestamp descending order, but my query is not working, here is my code:

 $this->db->order_by("DATE(field_name)", "DESC");

I am getting this, but when I display in jquery datatable, it became ascending order, how to solve this?

Answer 1

In jQuery Datatable, you have an config option to sort the table, by default, the first one. Be sure it is well positionned if you want to keep a specific data order.

$('#myDataTable').DataTable({
    order: [[0, 'desc']],
});

The first argument 0 is index of the column to sort by (here, the first column, 1 for the second one, etc).

Or, you can disable Datatable sorting, passing an empty array to the order option :

$('#myDataTable').DataTable({
    order: [],
});