Active Record: COUNT WHERE?

[eluser]OliverHR[/eluser]
This thread is not getting old, is old :lol:.

But I still have a comment to make.

What about this query:

Code:

function product_detail($customer, $session, $product_id)
    {
        $this->db->select('products.reference');
        $this->db->select_sum('price', 'total'); //by the way in the user guide
                                                 //documentation is incomplete.

        // I Would prefer a function at codeigniter's style!!!!
        $this->db->select('Count(product_id) AS quantity');


        $this->db->join('products', 'products.id = temp_order.product_id');
        // Repetitive, but very simple and clear(to me and the next one...)
        $this->db->where('customer_id', $customer);
        $this->db->where('cart_session', $session);
        $this->db->where('product_id', $product_id);

        $this->db->group_by('products.reference');

        $query = $this->db->get('temp_order');

        return $query->row_array();
    }

It would be easier if CI provide us a function like:

Code:

select_count($select = '', $alias = '')