****

**Controller:**

$this->load->model('Site_model');

$data1["results_drivers"]=$this->Site_model->get_table('drivers');

$this->load->view("admin/new_booking",$data1);

**Model:**

function get_table($table)
{

$query = $this->db->query("SELECT * FROM $table");

return $query->result();
}

**View:**

<div class="row mb40">
<div class="col-md-6">
<label>Driver</label>

<select name="dname" class="form-control">
// <?php

foreach($results_drivers as $row)
{
echo '<option value="'.$row->name.'">'.$row->name.'</option>';

}
?>
</select>

<?php echo form_error('dname'); ?>
<p class="help-block text-danger"></p>
</div>



<div class="col-md-6">
<label>Driver mob</label>
<select name="dmob" class="form-control">
// <?php

foreach($results_drivers as $row)
{
echo '<option value="'.$row->mob.'">'.$row->mob.'</option>';

}
?>
</select>

<?php echo form_error('dmob'); ?>
<p class="help-block text-danger"></p>
</div>
</div> ****