You have to add a property Totale in the activerecord class:
class TableName extendx CactiveRecord
{
public $totale;
then in the controller (or wherever you have to do it):
$criteria= new CDbCriteria;
$criteria->condition= "StartDate < '2010-02-01' AND StartDate >='2010-01-01' AND class='A' ";
$criteria->select=" COUNT(*) as Totale";
CActiveRecord::model($tableName)->find($criteria);
{
$criteria1= new CDbCriteria;
$criteria1->condition= "prj_start_date < '2010-03-01' AND prj_start_date >'2009-01-01' AND device_category_id='0' ";
$criteria1->select=" COUNT(*) as totale";
return new CActiveDataProvider(get_class($this), array(
'criteria'=>$criteria1,
));
}
The query you wrote will extract only the row for id 0, maybe you want to display all rows by using group by:
$criteria= new CDbCriteria;
$criteria->select="device_category_id COUNT(*) as Totale";
$criteria->condition= "StartDate < '2010-02-01' AND StartDate >='2010-01-01' AND class='A' ";
$criteria->group_by="device_category_id";
CActiveRecord::model($tableName)->find($criteria);