Yii - DB一次显示两列数据

Question

How to display the db data at once with different column?

This is my YII dropdown:

echo CHtml::dropDownList('select_gamecat',"",
     CHtml::listData(GamesType::model()->findAll(),
     'id', 'descr_en', 'descr'), //<--here
     array(
         'empty' =>  Yii::t('labels', 'choosecat'),
         'id' => "select_gamecat", 
         'class' => "inputs",
         'style'=>'width:369px'
      ));

I wish to combine the 'descr_en' and 'descr'

I tried 'desrc_en.desrc' and 'desrc_en + desrc' but both doesn't work.

Any Suggestion ? Thanks

Answer 1

You can try it with an anonymous function:

echo CHtml::dropDownList('select_gamecat',"",
     CHtml::listData(GamesType::model()->findAll(),
            'id', function($data){
                return $data->descr_en.$data->descr; 
            }),
     array('empty' =>  Yii::t('labels', 'choosecat'),'id' => "select_gamecat", 'class' => "inputs",'style'=>'width:369px'));

Explaination

Yii will check if the third parameter is an anonymous function, if yes, it will run it (with call_user_func) and the first parameter is the current model.