query builder

Try:

PHP Code:

$rs = $this->db->from('curriculum_subjects')
 ->where('curriculum_id', 20)
 ->where('curriculum_subject_semester', 'first')
 ->where('curriculum_subject_year_level', 1)
 ->get()
 ->result_array();