function getAll($offset, $limit = 2) { $this->db->select('article_title, article_body'); $this->db->from('article'); $this->db->where('article_published', 1); $this->db->orderby('article_published_date', 'desc'); $this->db->limit($limit,$offset); $result_set = $this->db->get(); $num_rows = $result_set->num_rows(); if ($num_rows > 0) { $output = ''; foreach ($result_set->result() as $row) { $output .= '
' . $row->article_body . '
'; } $output .= 'No articles found.
'; } return $output; }