search_model.php

<?php
public function search($searchterm,$limit)
{
  $sql = "SELECT * FROM Country 
          WHERE Continent LIKE '%" . $searchterm . "%' LIMIT " .$limit . ",20";
  $q = $this->db->query($sql);
  if($q->num_rows() > 0)
  {
    foreach($q->result() as $row)
    {
      $data[] = $row;
    }
    return $data;
  }
  else
  {
    return 0;
  }
}