how is convert this code to CodeIgniter code?

[eluser]Eric Barnes[/eluser]
You just need to make sure your query actually generates results before you loop it. Also:

Code:

$query = $this->db->order_by("id", "desc")->like('name', '$searchterm')->get('hotel_submits');

should be

Code:

$query = $this->db->order_by("id", "desc")->like('name', $searchterm)->get('hotel_submits');