{Solved} Pagination problem - Printable Version

Code:

function viewforum()

    {    

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

        

        $config['base_url'] = base_url().'forums/viewforum/'.$this->uri->segment(3).'/page/';

    

        $this->db->where('forum_id',$this->uri->segment(3));

        $get_results = $this->db->get('sb_topics');

        $count_results = $get_results->num_rows();

    

        $config['total_rows'] = $count_results;

        $config['per_page'] = 2;

        

        $this->db->where('forum_id',$this->uri->segment(3));

        $this->db->order_by('topic_time', 'DESC');

        $data['results'] = $this->db->get('sb_topics',$config['per_page'],$this->uri->segment(5));

        

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

        

        

        

        $this->template->load('forums/viewforum_view',$data);

    }

Code:

&lt;?php // Security



    $this->db->where('forum_id',$this->uri->segment(3));

    $query = $this->db->get('sb_forums');

    if (!$query->num_rows() > 0 ) redirect('forums');



?&gt;



<div class="forums">



    &lt;?php $this->load->view('forums/forum_header'); ?&gt;

    

     <table class="forum_topics" width="100%" style="border:1px solid #EEE;line-height:15px;" cellspacing="0">

     

     <tr>

         <td style="color:#fff;background-color:#FF6633;border-bottom:2px solid #999;font-size:12px;width:170px;padding-left:20px;"><b>Topics</b></td>

        <td style="color:#fff;background-color:#FF6633;border-bottom:2px solid #999;font-size:12px;width:50px"><b>Author</b></td>

        <td style="color:#fff;background-color:#FF6633;border-bottom:2px solid #999;font-size:12px;width:40px;text-align:center"><b>Replies</b></td>

        <td style="color:#fff;background-color:#FF6633;border-bottom:2px solid #999;font-size:12px;width:40px;text-align:center"><b>Views</b></td>

        <td style="color:#fff;background-color:#FF6633;border-bottom:2px solid #999;font-size:12px;width:100px"><b>Date Posted</b></td>

     </tr>

     

     &lt;?php foreach($results->result() as $row): ?&gt;

    &lt;?php

            $this->db->where('id',$row->poster_id);

            $query = $this->db->get('users');

            $users_row = $query->row();

    ?&gt;    

    <tr>

        <td style="border-top:1px solid #EEE;padding-left:20px;">

            <span style="font-size:12px;"><b><a >topic_id;?&gt;">&lt;?=$row->topic_title?&gt;</a></b></span><br />

            <span style="font-size:9px;">&lt;?=(ucfirst($users_row->username))?&gt;</span>

        </td>

        <td style="border-top:1px solid #EEE;">&lt;?=(ucfirst($users_row->username))?&gt;</td>

        <td style="border-top:1px solid #EEE;text-align:center;">&lt;?=$row->topic_replies?&gt;</td>

        <td style="border-top:1px solid #EEE;text-align:center;">&lt;?=$row->topic_views?&gt;</td>

        <td style="border-top:1px solid #EEE;">&lt;?=unix_to_human($row->topic_time)?&gt;</td>

    </tr>

    

    &lt;?php endforeach; ?&gt;

    

    </table>

    

    <div style="border:1px solid #CCC;margin-top:10px;background-color:#fff"><div style="border:1px solid #EEE;padding:5px">

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

    </div></div>



</div>