2 column table to form_dropdown array

[eluser]malzahar[/eluser]
Something like this may work.

In your model:

Code:

function get_names() {
   $names= array();
   $query = $this->db->get('table_name');
   if($query->num_rows() > 0) {
      foreach($query->result_array() as $name) {
         $names[] = $name;
      }
   }
   $query->free_result();
   return $names;
}

Your controller:

Code:

$this->load->model('model_name');
$data['names'] = $this->Model_Name->get_names();
$this->load->view('view_name', $data);

Your view:

Code:

foreach($names as $name) {
   echo "<option value='{$name['id']}'>{$name['name'}</option>";
}