$query->num_rows(); // Value is not expected .. This is not the total value

[eluser]meemeo[/eluser]
u can use

Code:

$query = $this->db->orderby(....);

$total_row = $this->db->count_all_results('table');
        
$query = $this->db->get('table', 10, 30);

hope is ur Ans ^ ^