jQuery UI Autocomplete with CI ??

[eluser]goldensona[/eluser]
Hi


this is my jquery ui autocomplete code i cant get the result come back from database it returns error.what wrong in my code please can someone correct my and guide me to solve this error

this Fatal error: Call to a member function num_rows() on a non-object in

view file

Code:

< cript t  ype="text/javascript" src="&lt;?php echo base_url()."jquery-ui-1.8.4.custom/development-bundle/jquery-1.4.2.js"?&gt;">[removed]
< cript t  ype="text/javascript" src="&lt;?php echo base_url()."jquery-ui-1.8.4.custom/development-bundle/ui/jquery.ui.core.js"?&gt;">[removed]
  < cript t  ype="text/javascript" src="&lt;?php echo base_url()."jquery-ui-1.8.4.custom/development-bundle/ui/jquery.ui.widget.js"?&gt;">[removed]
  < cript t  ype="text/javascript" src="&lt;?php echo base_url()."jquery-ui-1.8.4.custom/development-bundle/ui/jquery.ui.position.js"?&gt;">[removed]
< cript type="text/javascript" src="&lt;?php echo base_url()."jquery-ui-1.8.4.custom/development-bundle/ui/jquery.ui.autocomplete.js"?&gt;">[removed]


    
[removed]
//Javascript
$("input[name='singlecity']").autocomplete({
        source: function(req, add){
                $.ajax({
                    url: '&lt;?php echo site_url('search');?&gt;',
                    dataType: 'json',
                    type: 'POST',
                    data: req,
                    success: function(data){
                        if(data.response =='true'){
                           add(data.message);
                        }
                    }
                });
        },
        minLength: 3,
        select: function(event, ui){
            $(this).end().val(ui.item.value);
        }
     });
[removed]
&lt;/head&gt;

&lt;body&gt;
&lt;input type="text" name="singlecity"  size="48"&gt;

&lt;/body&gt;

this is my controller file

Code:

class Search extends Controller{
  
function Search(){
// load Controller constructor
parent::Controller();
// load the model we will be using
$this->load->model('searchcity', '', TRUE);
// load the database and connect to MySQL
$this->load->database();
// load the needed helpers
$this->load->helper('url');
}


  function index(){
     $search = $this->input->post('term');
        
        if(!IS_AJAX || empty($search))
            echo "no string";
        
        $data['response'] = 'false';
        
        $query = $this->searchcity->citysearch($search); //Search DB
     if($query->num_rows() > 0)
     {
        $data['response'] = 'true'; //Set response
        $data['message'] = array(); //Create array
        foreach($query->result() as $row)
        {
            $data['message'][] = array('label'=> $row->id, 'value'=> $row->city); //Add a row to array
        }
     }
        if(IS_AJAX)
        {
            echo json_encode($data); //echo json string if ajax request
        }
        else
        {
            $this->load->view('search',$data); //Load html view of search results
        }
  }

}  
?>

this is my model file

Code:

function citysearch($search)
{
   if(empty($part_number)) return FALSE; //nothing to search

   $this->db->like('city', '$search');

   $query = $this->db->get('townandcites');

  
   if($query->num_rows() > 0)

       return $query->result();

  return FALSE;
}

thanks