Help with Prefetching Next Record in DB

[eluser]pickupman[/eluser]
I used something like this before (similar to links at the bottom of the page for the forums. The part I don't like about my solution is having to return the query resource and not the result object.

Code:

//In model
return $query->get();

//In Controller
$destinations = $this->times_model->get_records($limit, $offset);

$id = $this->uri->segment(3,0); //Current ID
$i  = 0;
$marker = $destinations; //Copy result set

foreach($destinations->result() as $destination){

   if($destination->id == $id){
      $next     = $marker->row($i+1);
      $previous = $marker->row($i-1);
   }
   $i++;
}