SELECT COUNT GROUP BY

Yii 1.1 General Discussion
1

How to construct the following query

[sql]SELECT status,COUNT(*) as count FROM users GROUP BY status[/sql]

with the "User" AR model of the users table, the most efficient way?

2

Done it by using DAO instead, it uses less RAM.

3

Can you post what exactly you did?

4

Something like:




$dbCommand = Yii::app()->db->createCommand("

   SELECT status,COUNT(*) as count FROM `users` GROUP BY `status`

");


$data = $dbCommand->queryAll();
5

then in the views,it can user <?php foreach $data as ($n=>$dat):?>to display the data?