+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Using CodeIgniter (https://forum.codeigniter.com/forumdisplay.php?fid=5)
+--- Forum: General Help (https://forum.codeigniter.com/forumdisplay.php?fid=24)
+--- Thread: query builder (/showthread.php?tid=68067)
query builder - lloricode - 05-19-2017
```php
$rs = $this->db->query("SELECT *
FROM `curriculum_subjects`
WHERE (`curriculum_id` = 20
AND `curriculum_subject_semester` = 'first'
AND `curriculum_subject_year_level` = 1)")->result();
print_r($rs);
has a result
but really has no data, while in PHPmyadmin has no result
```
RE: query builder - Rufnex - 05-19-2017
You have to query the selected result e.g. with "$rs->result()" ...
https://www.codeigniter.com/userguide3/database/results.html
Edit: havent seen the use of result in your query ^^ .. sorry .. PaulD is right.
RE: query builder - PaulD - 05-20-2017
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();