Query Help

[lasanthapw (Lasantha26)]

hi

i have a table to collect business values according to users see figure 1

Then i want to group statement according to users see figure 2

here my actionIndex

public function actionIndex()

{


        $id = $_GET['pr'];


        $criteria=new CDbCriteria;


        $criteria->join="inner join user on user.id=UserID";


        $criteria->compare('ProjectID', $id, true);


        $criteria->order='username ASC';


	$dataProvider=new CActiveDataProvider('Businessvalue',array( 'criteria'=>$criteria));


	$this->render('index',array(


		'dataProvider'=>$dataProvider,


	));


            


            


}

please guide me do this right way

Thanks

5206

5207