Dynamically fill an array from Mysql using Form Helper for dropdown list.

[eluser]Unknown[/eluser]
[quote author="Tamer Solieman" date="1243385946"]Thanks DCZ it works fine for me :>[/quote]

I'm beginner and newbie in Code Igniter, i have tried this...

i was added :

Code:

function get_dropdown_array($key, $value, $from){
        $result = array();
        $array_keys_values = $this->db->query('select '.$key.', '.$value.' from '.$from.' order by id asc');
       foreach ($array_keys_values->result() as $row)
        {
            $result[$row->$key]= $row->$value;
        }
        return $result;
    }

on my model

then i load this result using

Code:

<?php  $options1=$this->Guest_model->get_dropdown_array('id', 'driver_name','guest_driver');
        
        ?>

<?=form_dropdown('driver', $options1, set_value('driver',isset($default['driver']) ? $default['driver'] : ''));?>

and it's work!..great thanks