蛋糕PHP计数不同 [英] Cake php count distinct

问题描述

如何使Cakephp查询的计数不同？

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

        ));

推荐答案

是这样吗？

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

这篇关于蛋糕PHP计数不同的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！