HoW to get unique vales from db query???

[eluser]umbongo[/eluser]
How do i get each unique value from a column in a db query so that i can use them in a dropdown form??

[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>";

[eluser]umbongo[/eluser]
Thanks!, works great.