Generating A Dropdown List From Db

Yii 1.1 General Discussion
1

In my DB there is a table called ‘Property’ , I need to populate property name in a drop down list , below code works fine regarding pulling out the data from DB, but it doesn’t set ‘name’ attribute on generated HTML.




<?php

        echo $form->dropDownList(

        $model,

        'name',

        CHtml::listData(Property::model()->findAll(array('order' => 'name')),'id','name')

);

        ?>

generates




<select name="Property[name]" id="Property_name">

<option value="1">Property 1</option>

<option value="2">Property 2</option>

<option value="3">Property 3</option>

</select>

But I need something like below




<select name="one" id="one">

<option value="1">Property 1</option>

<option value="2">Property 2</option>

<option value="3">Property 3</option>

</select>
2

Just do like this:




<?php

        echo $form->dropDownList(

        $model,

        'name',

        CHtml::listData(Property::model()->findAll(array('order' => 'name')),'id','name'),

array(

'id' => 'one',

'name' => 'one'

)

);

        ?>

http://www.yiiframework.com/doc/api/1.1/CHtml#activeDropDownList-detail

3

Many thanks. Works fine now.