Need help with writing a query!!!

[eluser]heylarson[/eluser]
I currently have:

Code:

//get the details for a particular event based off the event id
function GetEventView($id)
{
    $this->db->select('id')->from('events')->order_by('start_date', 'desc');
    $query = $this->db->get();
    
    // $query->result() should contain the array of event id's
    // the id of the event that the user is currently viewing
    // is passed as a parameter. I need to somehow capture the
    // event id of the event that occurs next in time.
}