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_title . '

'; $output .= '

' . $row->article_body . '

'; } $output .= '
'; if (($limit + $offset) -1 > $num_rows) { $prev = $limit-$offset; $output .= '<< Back'; } } else { $output = '

No articles found.

'; } return $output; }