Yii1.1：查询符合条件的记录个数

1、 通过find方法

$res = findAll(...); (or findAllByAttributes)
$num = count($res)

2、通过count方法

$res1 = countByAttributes(...);
$res2 = countBySql(...);

3、 通过query方法

$sql = "SELECT COUNT(*) as clients FROM client_table";  
$command = Yii::app()->db->createCommand($sql);  
$results = $command->queryAll();  
$numClients = (int)$results[0]["clients"];  

4、通过queryScalar可以让上面的语句更简单

$sql = "SELECT COUNT(*) FROM client_table";  
$numClients = Yii::app()->db->createCommand($sql)->queryScalar(); 

$sql = "select count(*) from ueb_product.ueb_ebay_online_listing as a";
            $sql .= " LEFT JOIN ueb_product.ueb_ebay_online_listing_variation e ON a.itemid = e.item_id";
            $sql .= " LEFT JOIN ueb_product.ueb_product d ON d.sku=a.sku";
            $sql .= " where {$where}";

            $total = Yii::app()->db->createCommand($sql)->queryScalar();