Need Help with a MySQL Query

PHP Code:

$query = $this->db->select('department,fullname')->from('employees')->order_by('department,fullname')->get();
$offset = '';
foreach($query->result() as $row) {
   if ($row->department != $offset) {
     echo '<h3>' . $row->department . '</h3>';
     $offset = $row->department;
   }
   echo '- ' . $row->fullname . '<br />';
} 


Works as intended, many thanks Wouter60.