Question : codeigniter order by
Answered by : terrible-tapir-3nc2zditw4iz
$this->db->from($this->table_name);
$this->db->order_by("name", "asc");
$query = $this->db->get();
return $query->result();
Source : https://stackoverflow.com/questions/5320395/codeigniter-order-by-on-a-query | Last Update : Thu, 11 Jun 20
Question : CodeIgniter get_where order_by
Answered by : black-batfish-82pfr1v8phxg
$query = $this->db->order_by('birth_date', 'ASC')->get_where($this->tbl_name, $where);
Source : https://stackoverflow.com/questions/13325962/codeigniter-get-where-order-by | Last Update : Sat, 26 Jun 21
Question : where_in codeigniter
Answered by : rafeek
$this->db->select('ae_users.employee_id, ae_users.emp_name, ae_users.emp_name2, ae_users.emp_name3'); $this->db->from('ae_users'); $this->db->where_in('ae_users.employee_id',$employee_ids); $query =$this->db->get(); if ($query->num_rows()) { return $query->result_array(); } else { return 0; }
Source : | Last Update : Wed, 23 Sep 20
Question : codeigniter order_by
Answered by : red-team
$this->db->order_by("UPPER(course_name)","desc");
Source : | Last Update : Wed, 30 Mar 22