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-->