Removing the keys from result_array()

[eluser]matula[/eluser]
This is probably a simple task, but I want to generate a single-level array from a resultset. This code:

Code:

$query = $this->db->select('id')->from('table')->get();
return $query->result_array()

... produces an array with "id" as the key. But I'd like to return a flat array like: array(3,5,8,12,etc)

Is there a way to do that in CI or PHP, or will I need to just loop through the array and create it myself like:

Code:

$myarray = array();
foreach($query->result_array() as $result){
  $myarray[] = $result['id'];
}

Thanks!