form_dropdown

[eluser]defectivereject[/eluser]
With mine i use something like this

Code:

$data = array();
        $this->db->select('value, id');
        $this->db->order_by('value','asc');
        $Q = $this->db->get('table');
         if ($Q->num_rows() > 0){
           foreach ($Q->result_array() as $row){
             $data[$row['id']] = $row['value'];
           }
        }
        $Q->free_result();  
        return $data;
     }

this always gives me a dropdowns with the id as "value" and the value as the display
in the order i specified in the model query

then just use

Code:

echo form_dropdown('location', $options, 9, $data);

and it loads the dropdown with 9 as the displayed value........?