Dependable Dropdown Not Getting Sorted

Yii 1.1 General Discussion
1 

public function actionUpdateCities()

    { 

	$cities = explode(",", $_POST['myArea']);

            //District			

			$data = Districts::model()->findAllByAttributes( array('emirateId'=> $cities), array('order'=>'emirateId DESC'));

            $data = CHtml::listData($data,'districtId','districtName');

            $dropDownDistricts = "<input type='checkbox' value=''>All Districts<br>";

            foreach($data as $value=>$name)

                $dropDownDistricts .= CHtml::tag('input', array('name'=>'district', 'type'=>'checkbox', 'value'=>$value),CHtml::encode($name),true). "<br>";

				

            // return data (JSON formatted)

            echo CJSON::encode(array(

              'dropDownDistricts'=>$dropDownDistricts

            ));

    }



<td><?php

$cities= array('2,1'=>'All Cities', '2'=>'Abu dhabi', '1'=>'Dubai');

            echo CHtml::dropDownList('myArea','', $cities,

                array(

					'class'=>"basic-search-input1",

                    'prompt'=>'Select City',

                    'ajax' => array(

                        'type'=>'POST',

                        'url'=>CController::createUrl('site/updateCitiesSearch'), 

                        'dataType'=>'json',

                        'data'=>array('myArea'=>'js:this.value'),  

                        'success'=>'function(data) {

                            $("#district").html(data.dropDownDistricts);

                        }',

            ))); 

?></td>

        </tr>

        <tr>

          <td><?php echo CHtml::dropDownList('district','', array()); ?></td>

        </tr>

using array(‘order’=>‘emirateId DESC’)); has no effect

2

You sholuld do something like this




	echo $form->labelEx($model,'category_id');

	$models = Category::model()->findAll(array('order' => 'category_name'));

 

	// format models as $key=>$value with listData

	$list = CHtml::listData($models, 'category_id', 'category_name');

	

	echo CHtml::dropDownList('Product[category_id]', $model->category_id, 

              					$list,

              					array('empty' => '(Select category)',

              					'class' => 'klass',

              					'style' => 'color:black;width:205px;',

              					)

              				 );
3 

$data = Districts::model()->findAllByAttributes( array('emirateId'=> $cities), array('order'=>'districtName'));

            $data = CHtml::listData($data,'districtId','districtName');

            $dropDownDistricts = "<input type='checkbox' value=''>All Districts<br>";

            foreach($data as $value=>$name)

                $dropDownDistricts .= CHtml::tag('input', array('name'=>'district', 'type'=>'checkbox', 'value'=>$value),CHtml::encode($name),true). "<br>";

still giving same unsorted result