ORDER BY In Codeigniter

Question

public function mandarin_2($limit = '', $offset = '')
    {
        $data['aktivisdcm1'] = $this->db->get_where('tb_imam', array('status' => 'Aktivis'))->result_array();

    $data['title'] = 'Absensi Mandarin 2';
    $this->load->view('absensi/mandarin_2', $data);
    $this->load->view('templates/header');
    // $this->load->view('templates/footer');
}

please help .. how do I make an order by my coding? thank you, I really hope the response

Like This? $data['aktivisdcm1'] = $this->db->order_by("nama", "asc") get_where('tb_imam', array('status' => 'Aktivis'))->result_array(); — Edwin Nick, Jan 18 '20 at 05:22
Does this answer your question? [CodeIgniter - ORDER BY on a query](https://stackoverflow.com/questions/5320395/codeigniter-order-by-on-a-query) — Masoud Keshavarz, Jan 18 '20 at 05:33
Like this : `$data['aktivisdcm1'] = $this->db->order_by("nama", "asc")-> get_where('tb_imam', array('status' => 'Aktivis'))->result_array();` — Talk2Nit, Jan 18 '20 at 05:37

score 1 · Answer 1 · answered Jan 18 '20 at 05:41

1

You can check their documentation right here for their ordering results. This is how they do it.

$this->db->order_by('title', 'DESC');
// Produces: ORDER BY `title` DESC

CodeIgniter Documentation Query Builder Class Ordering Results

answered Jan 18 '20 at 05:41

Carljul

111
1
4

score 1 · Answer 2 · edited Jan 21 '20 at 06:22

1

I try this to solve:

$data['aktivisdcm1'] = $this->db->order_by("nama", "asc")-> get_where('tb_imam', array('status' => 'Aktivis'))->result_array();

edited Jan 21 '20 at 06:22

Shawn

1,232
1
14
44

answered Jan 18 '20 at 06:27

Edwin Nick

39
6

ORDER BY In Codeigniter

2 Answers2