Getting Dropdownlist Alphabetically

I am using the below code and would like my results to appear alphabetically that is A-Z





   $list=CHtml::listData(City::model()->findAll(),'city_id','city_name');

                        echo $form->dropDownList($model,'city', $list,array('empty'=>'Please Select')); 




How will I get them so?

in the database they are arranged in any order

If you want this content to be ordered alphabetically in other places too, you could place this in your City model:


public function defaultScope()

{

    return array("order" => "city_name");

}