Hi,
i have using Yii pagination but dunno why, when apply it, the first page list lest than 1 item but the continue page was load correctly, did my code is wrong?
$criteria =new CDbCriteria;
$criteria->select='c2c_products_listing_id, c2c_products_instant_id,products_id, products_title, products_description, available_quantity,
products_price, products_base_currency, products_display, delivery_mode, created_date, expiry_date';
if($referenceId==""){
$criteria->condition="t.game_id = :gameId AND t.custom_products_type = :productType";
$criteria->params=array(':gameId'=>$gameId,':productType'=>$productType);
}else{
$criteria->condition="t.game_id = :gameId AND t.custom_products_type = :productType AND t.c2c_products_listing_id = :referenceId";
$criteria->params=array(':gameId'=>$gameId,':productType'=>$productType,':referenceId'=>$referenceId);
}
$criteria->with = array('c2c_products_listing_media'=>array('select'=>'media_url'),
'c2c_products_hla'=>array('select'=>'products_account_id, products_hla_id'),
);
$count = $modelC2cProductsListing->model()->count($criteria);
$pages=new CPagination($count);
echo $count;
$pages->pageSize= '2';//C2C_LISTING_PER_PAGE;
$pages->applyLimit($criteria);
$pages->params = array('listingType'=>'1','gameId'=>$gameId,'productType'=>$productType);
$models = $modelC2cProductsListing->model()->findAll($criteria);
Count was show 4, correct.
At page 1 load one product, 2nd product missing
At page 2 load 2 product, all correct.