Yii findAllByAttributes BETWEEN DATE AND ORDER

Question

Im tring to search by attributes, given date range and sorted by date 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') ); 

Thanks in advance.

Answer 1

I had to use CDbCriteria , for example:

 $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 this helps someone in the future

Answer 2

You can use for:

 $criteria = new CDbCriteria; $criteria->condition = "date_start >= '$date_start' AND date_end <= '$date_end'"; $model = TemporadaAlta::model()->find($criteria);