I’d like to run SQL query “select * from member limit 20,5”
How to run it in Yii???
I’ve tried this:
$cri=new CDbCriteria;
$cri->limit=20,5;
$query=member::model()->findall($cri);
But it returned with error code…
Need help, please…
I’d like to run SQL query “select * from member limit 20,5”
How to run it in Yii???
I’ve tried this:
$cri=new CDbCriteria;
$cri->limit=20,5;
$query=member::model()->findall($cri);
But it returned with error code…
Need help, please…
Haven’t used yet, but try with:
$cri->offset=20;
$cri->limit=5;
offest detail - http://www.yiiframework.com/doc/api/CDbCriteria#offset-detail
limit detail - http://www.yiiframework.com/doc/api/CDbCriteria#limit-detail
It worked…
Thanks, mdomba…