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

[eluser]pasquattro[/eluser]
Thanks a lot DCZ, for both the code and explanation, I really appreciate it.

[eluser]scud[/eluser]
Great!
Solved my problem on populating drop down form

[eluser]sujitrulz[/eluser]
hi dcz,
i know this post quite old but i have some problem.i am new to CI infact 2 days old.

i want to populate data in dropdown. i have used your later function .
thisi s what i did so far
in model..

Code:

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

in controller

Code:

function dropdown()
{    
$this->load->model('Dropdown_model');
  $this->data['drop'] = $this->Dropdown_model->get_dropdown_array('uid', 'name','users');
    }

in view

Code:

<?=form_dropdown('uid', $drop,'uid');?>

but i am getting error like

A PHP Error was encountered

Severity: Notice

Message: Undefined variable: drop

Filename: views/signup.php

Line Number: 34
A PHP Error was encountered

Severity: Warning

Message: Invalid argument supplied for foreach()

Filename: helpers/form_helper.php

Line Number: 310

[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