Cake php count distinct

Question

Cake php count distinct

How can I make this Cakephp request to be considered different?

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

        ));

+2

cakephp

Mr sorbose 02 dec. 13 at 16:05

source to share

1 answer

C Travel · Accepted Answer · 2013-12-02T16:09:46+0000

Something like that?

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

Cake php count distinct

More articles: