Query Order By in Codeigniter

Question

How can display thus code in order by in Codeigniter

<ul id="sortable">
    <?php


   $query = $this->db->get('drag');

    foreach ($query->result() as $row)
    {
            echo '<li class="ui-state-default" title="'.$row->main_category_id.'" data-id="'.$row->id.'">'.$row->feeld.' <button type="button" class="btn btn-danger delbtn" id="dlbtn" data-ids="'.$row->id.'"><i class="fa fa-trash" aria-hidden="true"></i></button></li>';
    }
    ?>

score 0 · Answer 1 · answered Apr 13 '20 at 07:56

0

You can use order_by function.

$query = $this->db->order_by("id","DESC")->get('drag');

answered Apr 13 '20 at 07:56

Dum

1,431
2
9
23

score 0 · Answer 2 · answered Apr 13 '20 at 08:59

0

//you can use ASC or DESC 
$this->db->order_by("created_at", "asc")->get->result_array();

answered Apr 13 '20 at 08:59

PHP Geek

3,949
1
16
32

Query Order By in Codeigniter

2 Answers2