Login

09-19-2012, 02:12 AM

[eluser]zoreli[/eluser]
Hi

I haave problem with paging. I have 7 records in the database, and when
page is displayed all 7 records are displayed instead of 5, as I would like to be.

Sure enough, links for the paging are not displayed.

Here is my controller code:

Code:
public function displayAllFaqCategories()

        {

             //initializing & configuring paging

            $currentUser = $this->isLoggedIn();

            $this->load->model('faqCategoriesModel');

            $this->db->order_by('sorder');

            $limit = 5;

            $offset = 3;

            $offset = $this->uri->segment(3);

            $this->db->limit(5, $offset);

            $data['faq_categories'] = $this->faqCategoriesModel->selectCategoriesAndParents();

            $totalresults = $this->db->get('faq_categories')->num_rows();

            //initializing & configuring paging

            $this->load->library('pagination');

            $config['base_url'] = site_url('/backOfficeUsers/faqcategories');

            $config['total_rows'] = $totalresults;

            $config['per_page'] = 5;

            $config['uri_segment'] = 3;

            $this->pagination->initialize($config); 

            $errorMessage = '';

            $data['main_content'] = 'faq/faqcategories';

            $data['title'] = 'FAQ Categories';

            $this->load->vars($data,$errorMessage);

            $this->load->vars($currentUser);

            $this->load->view('backOffice/template');

        } // end of function displayAllFaqCategories

And here is my model code:

Code:
public function selectCategoriesAndParents($selectWhat = array())

       {    

           $data = array();

           $query = $this->db->query("SELECT fq . * , COALESCE( fqp.$this->parent_name,  '0' ) AS parentname

                                      FROM $this->table_name AS fq

                                      LEFT OUTER JOIN $this->table_name AS fqp ON fqp.catid = fq.parentid"); 

           if($query->num_rows() > 0) 

           {

               foreach($query->result_array() as $row) 

                   {

                       $data[] = $row;  

                   }

               }           

           $query->free_result();

           return $data;

       } // end of function selectCategoriesAndParents

In the view, bellow of the table with the records I have the following code:

Code:
&lt;?php echo $this->pagination->create_links();?&gt;

Any help will be deeply appreciated.

Regards,zoreli