[eluser]Unknown[/eluser]
Can any body help me in here... i've read a lot of this but figure it out...
here my code:
Controller:
$config['base_url'] = base_url() . 'dean/display_tl';
$config['total_rows'] = $this->db->count_all('list_of_teaching_assignments');
$config['per_page'] = 5;
$config['full_tag_open'] = '<div id="pagination">';
$config['full_tag_close'] = '</div>';
$this->pagination->initialize($config);
$this->db->from ('user');
$this->db->join ('list_of_teaching_assignments','user.user_id=list_of_teaching_assignments.user_id', 'inner');
$this->db->where('type','Teacher');
$this->db->where('is_authenticated', '1');
$data['query'] = $this->db->get('',$config['per_page'], $this->uri->segment(3));
and my view:
<?php foreach($query->result_array() as $row)
{
echo "<tr";
echo "<td>" . $row['last_name'] . "</td>";
echo "<td>" . $row['first_name'] . "</td>";
echo "<td>" . $row['courses_subjects'] . "</td>";
echo "<td>" . $row['role_in_course'] . "</td>";
echo "<td>" . $row['teaching_load'] . "</td>";
echo "<td>" . $row['semester'] . "</td>";
echo "<td>" . $row['school_year'] . "</td>";
echo "</tr>";
}
echo "</table>";
echo $this->table->generate($query);
echo $this->pagination->create_links();
?>
any ideas on how to do it?
thanks in advance