method for counting search results

search_model.php

<?php
public function search_record_count($searchterm)
{
    $sql = "SELECT COUNT(*) As cnt FROM Country
            WHERE Continent LIKE '%" . $searchterm . "%'";
    $q = $this->db->query($sql);
    $row = $q->row();
    return $row->cnt;
}