Number of query?

[eluser]rochellecanale[/eluser]
Try something like this:

Code:

public function countRegularAccount(){
            $this->db->like('fkproduct', 37);
            $this->db->from('sales_line');
            $query =  $this->db->count_all_results();
            return $query;
}

[eluser]Goka[/eluser]
i use

$query->num_rows()

example:

Code:

$this->db->select('productID');
$this->db->from('products');
$query = $this->db->get();
return $query->num_rows();