根据原始sql
from table_name
丢失:
SELECT * WHERE `p_code` = ...
所以你丢了你的桌子:
$q = $this->db->get('table_name');
public function getOfficer()
{
$usr = $this->session->userdata('id_user');
if ($usr == 4) {
$query = $this->db->order_by('last_name','ASC')->where_in('tbl_officer.p_code', [8,10,24]);
} else {
$query = $this->db->order_by('last_name','ASC')
->where(array('status' => 1, 'usr'=>$usr));
}
$query = $query->get('tbl_officer');
if ($query->num_rows() > 0) {
return $query->result();
} else {
return false;
}
}