[eluser]mysterious[/eluser]
I will do something like this.
Code:
$query = "SELECT DISTINCT field_name FROM table_name";
$results = $this->db->query($query)->result_array();
echo "<select>";
$foreach($results as $result)
echo "<option>$result['field_name']</option>";
echo "</select>";