count all results pagination problem

[eluser]Dave @ Exp:resso[/eluser]
I came across this while searching for how to count all results for a query excluding the limit.

Anyway, taking a compete stab in the dark here, but perhaps it is because you are specifying the table in the get() function? Have you tried

Code:

$this->db->from('liveauctions');
$this->db->limit($per_page, $offset);

as separate lines, and then just using

Code:

$this->db->get();
$this->db->count_all_results();

?