FindAll() in Yii

$models = Vehicle::model()->findAll( array('order' => 'vehicle_no'));

FindAll with Where clause = condition

​MainMenu::model() -> findAll(array("condition"=>"res_id =  $res_id","order"=>"name"));​

FindAll with Where clause Like condition

$Staff= CHtml::listData(AuthAssignment::model() -> findAll('itemname LIKE :Staff',array(':Staff' => "%Staff%")), 'userid', 'userid');

Joining Two tables

$criteria=new CDbCriteria;

$criteria->select = 't.userid,users.username';

$criteria -> join = 'JOIN  users on userid= users.id';

$criteria->condition = 'itemname LIKE :Staff OR itemname LIKE :Admin OR itemname LIKE :Cashier'; 

$criteria->params    = array(':Staff'=>'%Staff%',':Admin'=>'%Admin%',':Cashier'=>'%Cashier%'); 

$criteria->order = 'username DESC,userid DESC';

$Staff = AuthAssignment::model()->findAll($criteria);

$StaffList= CHtml::listData($Staff, 'userid', 'username');

​echo $form->dropDownList($model,'emp_id',$StaffList);​