how to fetch field values from database and set in dropdown using codeigniter

Question

I am new in CodeIgniter and working on a application in which i have a form. In this form I have a dropdown. I have some values in a column of database. I want these values in the dropdown, I have no idea how to do it.

My view is:

<tr>
    <td>Moderator :</td>
    <td><label for="select"></label>
    <select name="mod" tabindex="1" >
    <!--values i want from database-->
    </select>
    </td>
</tr>

Answer 1

This example is for a country table in our application, the table contains, id, symbol, name

Controller:

$data['countries']=$this->countries_model->get_countries();
$this->load->view('countries',$data);

Model:

    function get_countries()
    {
        $query = $this->db->get('countries');
            if ($query->num_rows >= 1)
            {
                foreach($query->result_array() as $row)
                {
                    $data[$row['countryId']]=$row['countryName'];
                }
                return $data;
            }
    }

It returns an array like:

$id=>$name
0=>Canada
1=>United States

View:

echo form_dropdown('countries',$countries); //ci syntax

Or:

<select name="country">
<?php
    foreach($countries as $country)
    {
       echo '<option value="'.$country['id'].'">'.$country['name'].'</option>';
    }
?>
</select>