Pagination With One Page

Yii 1.1 General Discussion
1

Hi I want to create a pagination with one data each page. please help :(

//controller

$sql="SELECT Emp_Code FROM opp.c_security WHERE PRFPLUS = ".$prf." AND Optimal = ".$opt." AND ServiceCtr = ".$srv." AND Uni = ".$uni."";

            $remp = Yii::app()->db->createCommand($sql)->queryAll();





            $sqls="SELECT * FROM `someen`";


            $rsomeen = Yii::app()->db->createCommand($sqls)->queryAll();





            $sql1="SELECT * FROM `someen` `t` INNER JOIN `so_details` `details` ON (`details`.`DocNo`=`t`.`DocNo`)";


            $rdet = Yii::app()->db->createCommand($sql1)->queryAll();





            $this->layout = 'column1';


            $this->render('unison',array('remp'=>$remp,'rsomeen'=>$rsomeen,'rdet'=>$rdet));

view

<?php

 foreach(&#036;remp as &#036;emp){


       foreach(&#036;rsomeen as &#036;someen){


            if(&#036;emp['Emp_Code']==&#036;someen['UserID']){

//content to paginate

}

}

}

}

?>