Basic question about count_all_results()

[eluser]Unknown[/eluser]
Hello everybody,

I have a simple question about the count_all_results method of Active Record. I have 2 entries in my table (returned by the following query):

Code:

$data['query'] = $this->db->get_where('produits', array('categories_id' => $this->uri->segment(3)));

And, when I put the total in the following variable:

Code:

$data['total'] = $this->db->count_all_results();

I'm always getting 1 instead of 2. Do you guys have an idea?

Thanks.