ninjahsu
(Ninjahsuccc)
1
$criteria=new CDbCriteria;
$criteria->condition='users_info.language_id=:languageID';
$criteria->params=array( ':languageID' => $this->_lang_id );
$criteria->order = 'users_info.products_id ASC';
$limit = count( $users_models = Users::model()->with(
'users_info', 'users_content' )->findAll( $criteria ) );
$pages=new CPagination( $limit );
$pages->pageSize=self::PAGE_SIZE;
$pages->applyLimit($criteria);
$users_models = Users::model()->with( 'users_info',
'users_content' )->findAll( $criteria );
When i ran these codes above, something happened.
I used "findAll()" to query my db, it worked at the first time.
But after running this line ,"$pages=new CPagination( $result_limit );",
the function "findall()" always comes out the wrong result.
Can anyone tell me why?
look this post http://www.yiiframework.com/forum/index.php?/topic/6591-active-recordquery-condition-based-on-a-related-model-attribute/