$this->db->limit() working differently? |
MySQL data fetch query as limit and offset. You can use this code for limit query
function getRecords($searchData) { $search_index = '2'; $limit = "10"; $this->db->limit($limit,$search_index); $this->db->where('status','Active'); $this->db->order_by($this->table.'.add_date', 'desc'); $this->db->where('approve_status','Approved'); $this->db->where('type','Blog'); $query = $this->db->get($this->table); $result = $query->result(); return $result; } |
Messages In This Thread |
$this->db->limit() working differently? - by Ornis - 11-13-2016, 03:35 AM
RE: $this->db->limit() working differently? - by InsiteFX - 11-13-2016, 04:26 AM
RE: $this->db->limit() working differently? - by XtreemDeveloper - 12-21-2017, 10:22 AM
|