Cake php count distinct

Question

How can this Cakephp query be made to count distinct?

        $matches = $this->Product->find('count', array(
            'conditions' => array(
                "Product.brand_id" => $brand['Brand']['id'],
                'Product.active' => 1

        ));

Carl0s1z · Accepted Answer · 2013-12-02 16:09:46Z

5

Something like this?

$matches = $this->Product->find('count', array(
    'fields' => 'DISTINCT Product.brand_id',
    'conditions' => array("Product.brand_id" => $brand['Brand']['id'],
            'Product.active' => 1)
    ));

answered Dec 2, 2013 at 16:09

Carl0s1z

4,7237 gold badges34 silver badges49 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

mark Over a year ago

I recommend using a virtual field here instead. And a group by statement.

Collectives™ on Stack Overflow

Cake php count distinct

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related