Yii findAllByAttributes with BETWEEN DATES and ORDER BY

php, yii

Solution

Had to use a CDbCriteria, like this:

$attribs = array('user_country'=>1 ,'user_gender'=>'M');
$criteria = new CDbCriteria(array('order'=>'user_date_created DESC','limit'=>10));
$criteria->addBetweenCondition('user_date_created', $date['date_start'], $date['date_end']);
$rows = user::model()->findAllByAttributes($attribs, $criteria);

Hope it helps somebody in the future

Problem

Im tring to do a search by attributes, on a given date range and ordered by date created, but no luck. ``` $user = array('user_country'=>1 ,'user_gender'='M'); $rows = User::model()->findAllByAttributes($user,array("user_date_created BETWEEN '2012' AND '2013' " ,'order'=> 'user_date_created') ); ``` Thank you in advance.

Original source