place Ascending order in were clause

Yii 1.1 General Discussion
1

hi all,

i have a 2 columns charges(charge1,charge2…) and priority(1,2…).

I want to display charges in the ascending order of priority .

the query i wrote is




  $chrgtopay = Yii::app()->db->createCommand()

                        ->select('Demand_type')

                        ->from('tbl_charges_demand_details')

                        ->where('Demand_flat_number=:Demand_flat_number', array(':Demand_flat_number'=>$id))

                        ->queryColumn();
2 

$chrgtopay = Yii::app()->db->createCommand()

                        ->select('Demand_type')

                        ->from('tbl_charges_demand_details')

                        ->where('Demand_flat_number=:Demand_flat_number', array(':Demand_flat_number'=>$id))

                        ->order(' charge DESC priority ASC')

                        ->queryColumn();

For example

3

Thanks for it zaccaria i got it