problem drop -down dynamically

Well the easiest without model is

PHP Code:

<?php

//in some controller

function method_name(){
  $data['rows'] = $this->db->select('id, name')->get('users');
  $this->load->view('some_view', $data);
} 


PHP Code:

<!-- some view -->

<?php foreach($rows->result_array() as $row): ?>
  <?php echo $row['id']; ?>
  <?php echo $row['name']; ?>
<?php endforeach; ?>
<!-- just add the HTML and you are ready--> 


Just notice in the image you are loading the database in there not sure why. I would recommend using the config/database.php and autoload the library

There's only one rule - please don't tell anyone to go and read the manual.  Sometimes the manual just SUCKS!