ORDER By in Codeigniter Model

Question

    $query = ('SELECT tb_imam.*, tb_bidang.bidang
                 FROM tb_imam JOIN tb_bidang
                   ON tb_imam.bidang_id = tb_bidang.id
                WHERE tb_imam.status = "Pengerja"
            ');

    return $this->db->query($query)->result_array();

How do I add an order by using my code like this? beg for your help, thank you

Answer 1

Just use ORDER BY

$query = "SELECT tb_imam.*, tb_bidang.bidang
         FROM tb_imam 
         JOIN tb_bidang ON tb_imam.bidang_id = tb_bidang.id
         WHERE tb_imam.status = 'Pengerja' 
         ORDER BY prefix.column_name";

return $this->db->query($query)->result_array();

JOIN !== LEFT JOIN

Get used to Query Builder Class.

Answer 2

Here you are using raw query like mysql query, so you can directly add "order by" clause at the end of the "where" clause,

 $query = ('SELECT tb_imam.*, tb_bidang.bidang
             FROM tb_imam JOIN tb_bidang
               ON tb_imam.bidang_id = tb_bidang.id
            WHERE tb_imam.status = "Pengerja"
            ORDER BY column_name');

return $this->db->query($query)->result_array();

Answer 3

$this->db->select("tb_imam.*,tb_bidang.bidang");

$this->db->from("tb_imam");

$this->db->join("tb_bidang","tb_imam.bidang_id = tb_bidang.id");

$this->db->where("tb_imam.status","Pengerja");

$this->db->order_by("column_name");

$this->db->get()->result_array();