By using Yii list view, i want to show the results as group.
This is the mysql data
data1 - 2013-04-09 07:29:05
data2 - 2013-04-09 08:30:00
data3 - 2013-04-09 08:45:10
data4 - 2013-04-08 11:00:05
data5 - 2013-04-08 10:15:35
data6 - 2013-04-06 06:20:15
data7 - 2013-04-06 06:20:05
Would like to show the result in CList view like this
DATE - 2013-04-09
data1
data2
data3
DATE - 2013-04-08
data4
data5
DATE - 2013-04-06
data6
data7
Controller action
$criteria = new CDbCriteria();
$criteria->select = "`data`, `time`";
$criteria->group='time';
$criteria->order='time DESC';
$data=new CActiveDataProvider('Message',array('criteria'=>$criteria,'pagination'=>array('pageSize'=>10)));
$this->render('index', array(
'ModelInstance' => Message::model()->findAll($criteria),
'dataProvider'=>$data
));
How it show like that?
Thanks.