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

Since you're using a raw SQL string anyway, just add it to the raw string e.g. $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 something '); — ADyson
– ADyson, Commented Jan 20, 2020 at 10:42

Abdulla Nilam · Accepted Answer · 2020-01-20 10:48:03Z

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();

halfer · Accepted Answer · 2020-02-09 22:37:55Z

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.

marc_s · Accepted Answer · 2023-08-27 16:48:35Z

$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();

While this code may answer the question, providing additional context regarding how and/or why it solves the problem would improve the answer's long-term value.

Collectives™ on Stack Overflow

ORDER By in Codeigniter Model

3 Answers 3

Comments

Comments

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

1 Comment

Linked

Related