Search Pagination...

Yii 1.1 General Discussion
1

i have several table… which i made it search very well but pagination is not working properly…

i attached my pagination code and search option pl suggest me suitable answer please

my controller is :

foreach ($bigArray as $index => $bigArray)

{  


 


  $result1="SELECT * from recipe WHERE recipe_id=$bigArray";


   $QueryForData2=Yii::app()->db->CreateCommand($result1)->queryAll();    


   foreach ($QueryForData2 as $data) {


        $r_id=$data['recipe_id'];


               $recipeArray[]=$r_id;


                }

}

        $criteria = new CDbCriteria;


        


       $pages=new CPagination($recipeArray);


      $pages->pageSize=2;


       $pages->applyLimit($criteria);


        $this->render('search',array('model'=>$model,'count1'=>$recipeArray,'pages'=>$pages));


       


   


    }

my view file is::

<?php

foreach($count1 as $rec):

$rec_id=$rec;

$recipe_q1=Recipe::model()->find("recipe_id=$rec_id");

…

…

<?php endforeach ?>