title: Problem using jqGrid Search Function
body: <p>I am new to jqgrid, but really want to get to grips with it. I am having a hard time getting the Search function to work. Here is the XML I am working with:</p>
  
  <pre><code>&lt;?xml version='1.0' encoding='utf-8'?&gt;
  &lt;rows&gt;
      &lt;page&gt;1&lt;/page&gt;
      &lt;total&gt;1&lt;/total&gt;
      &lt;records&gt;3&lt;/records&gt;
          &lt;row id='1'&gt;
              &lt;cell&gt;1&lt;/cell&gt;
              &lt;cell&gt;5 Little Roodee&lt;/cell&gt;
              &lt;cell&gt;Hawarden&lt;/cell&gt;&lt;cell&gt;CH5 3PU&lt;/cell&gt;
              &lt;cell&gt;895.00&lt;/cell&gt;
              &lt;cell&gt;1&lt;/cell&gt;
          &lt;/row&gt;
          &lt;row id='2'&gt;
              &lt;cell&gt;2&lt;/cell&gt;
              &lt;cell&gt;28 Pant-y-Fawnog&lt;/cell&gt;
              &lt;cell&gt;Buckley&lt;/cell&gt;
              &lt;cell&gt;CH7 2PD&lt;/cell&gt;
              &lt;cell&gt;610.00&lt;/cell&gt;
              &lt;cell&gt;0&lt;/cell&gt;
          &lt;/row&gt;
          &lt;row id='3'&gt;
              &lt;cell&gt;3&lt;/cell&gt;
              &lt;cell&gt;60 Langford Crescent&lt;/cell&gt;
              &lt;cell&gt;Buckley&lt;/cell&gt;
              &lt;cell&gt;CH7 2PR&lt;/cell&gt;
              &lt;cell&gt;625.00&lt;/cell&gt;
              &lt;cell&gt;1&lt;/cell&gt;
          &lt;/row&gt;
  &lt;/rows&gt;
  </code></pre>
  
  <p>As you can see its fairly simple. Now here is the jqgrid declaration I am using:</p>
  
  <pre><code>$(function(){ 
            $("#list").jqGrid({
              url:'xml_properties_jq.php',
              datatype: 'xml',
              mtype: 'GET',
              colNames:['ID','Address', 'Town','Postcode','Rent. Val','Active'],
              colModel :[ 
                {name:'property_id', index:'property_id', width:40}, 
                {name:'property_add_1', index:'property_add_1', width:150}, 
                {name:'property_add_town', index:'property_add_town', width:80, align:'right', searchoptions: { sopt: ['eq', 'ne']}}, 
                {name:'property_add_postcode', index:'property_add_postcode', width:80, align:'right'}, 
                {name:'property_rentable_value', index:'property_rentable_value', width:80, align:'right'}, 
                {name:'property_active', index:'property_active', width:60}
              ],
              pager: '#pager',
              rowNum:10,
              rowList:[10,20,30],
              sortname: 'property_id',
              sortorder: 'desc',
              viewrecords: true,
              caption: 'Properties'
            })
            //jQuery("#list").jqGrid('navGrid','#pager',{edit:false,add:false,del:false});
            .navGrid('#pager',{view:true, del:false}, 
  {}, // use default settings for edit
  {}, // use default settings for add
  {},  // delete instead that del:false we need this
  {multipleSearch : false}, // enable the advanced searching
  {closeOnEscape:true} /* allow the view dialog to be closed when user press ESC key*/
  );
  }); 
  </code></pre>
  
  <p>Finally here is the PHP which constructs my XML:</p>
  
  <pre><code>&lt;?php 
  //include the information needed for the connection to MySQL data base server. 
  // we store here username, database and password 
  include("Connections/db.php");
  
  // to the url parameter are added 4 parameters as described in colModel
  // we should get these parameters to construct the needed query
  // Since we specify in the options of the grid that we will use a GET method 
  // we should use the appropriate command to obtain the parameters. 
  // In our case this is $_GET. If we specify that we want to use post 
  // we should use $_POST. Maybe the better way is to use $_REQUEST, which
  // contain both the GET and POST variables. For more information refer to php documentation.
  // Get the requested page. By default grid sets this to 1. 
  $page = $_GET['page']; 
  
  // get how many rows we want to have into the grid - rowNum parameter in the grid 
  $limit = $_GET['rows']; 
  
  // get index row - i.e. user click to sort. At first time sortname parameter -
  // after that the index from colModel 
  $sidx = $_GET['sidx']; 
  
  // sorting order - at first time sortorder 
  $sord = $_GET['sord']; 
  
  // if we not pass at first time index use the first column for the index or what you want
  if(!$sidx) $sidx =1; 
  
  // connect to the MySQL database server 
  //$db = mysql_connect($dbhost, $dbuser, $dbpassword) or die("Connection Error: " . mysql_error()); 
  
  // select the database 
  //mysql_select_db($db) or die("Error connecting to db."); 
  mysql_select_db($database_eazylet, $eazylet);
  
  // calculate the number of rows for the query. We need this for paging the result 
  $result = mysql_query("SELECT COUNT(*) AS count FROM p_properties", $eazylet); 
  //$row = mysql_fetch_array($result,MYSQL_ASSOC); 
  $row = mysql_fetch_assoc($result);
  $count = $row['count']; 
  
  // calculate the total pages for the query 
  if( $count &gt; 0 &amp;&amp; $limit &gt; 0) { 
                $total_pages = ceil($count/$limit); 
  } else { 
                $total_pages = 0; 
  } 
  
  // if for some reasons the requested page is greater than the total 
  // set the requested page to total page 
  if ($page &gt; $total_pages) $page=$total_pages;
  
  // calculate the starting position of the rows 
  $start = $limit*$page - $limit;
  
  // if for some reasons start position is negative set it to 0 
  // typical case is that the user type 0 for the requested page 
  if($start &lt;0) $start = 0; 
  
  // the actual query for the grid data 
  $SQL = "SELECT * FROM p_properties ORDER BY $sidx $sord LIMIT $start , $limit"; 
  $result = mysql_query($SQL, $eazylet) or die("Couldn't execute query.".mysql_error()); 
  
  // we should set the appropriate header information. Do not forget this.
  header("Content-type: text/xml;charset=utf-8");
  
  $s = "&lt;?xml version='1.0' encoding='utf-8'?&gt;";
  $s .=  "&lt;rows&gt;";
  $s .= "&lt;page&gt;".$page."&lt;/page&gt;";
  $s .= "&lt;total&gt;".$total_pages."&lt;/total&gt;";
  $s .= "&lt;records&gt;".$count."&lt;/records&gt;";
  
  // be sure to put text data in CDATA
  while($row = mysql_fetch_array($result,MYSQL_ASSOC)) {
  //while($row = mysql_fetch_assoc($result)) {
      $s .= "&lt;row id='". $row['property_id']."'&gt;";            
      $s .= "&lt;cell&gt;". $row['property_id']."&lt;/cell&gt;";
      $s .= "&lt;cell&gt;". $row['property_add_1']."&lt;/cell&gt;";
      $s .= "&lt;cell&gt;". $row['property_add_town']."&lt;/cell&gt;";
      $s .= "&lt;cell&gt;". $row['property_add_postcode']."&lt;/cell&gt;";
      $s .= "&lt;cell&gt;". $row['property_rentable_value']."&lt;/cell&gt;";
      $s .= "&lt;cell&gt;". $row['property_active']."&lt;/cell&gt;";
      $s .= "&lt;/row&gt;";
  }
  $s .= "&lt;/rows&gt;"; 
  
  echo $s;
  ?&gt;
  </code></pre>
  
  <p>All the sorting works fine in the grid so I assume the data is OK.</p>
  
  <p>My problem is that when I hit the search button, enter any valid criteria (i.e. ID = 1) and click FIND, nothing happens. The search box remains and the list has not been filtered.</p>
  
  <p>I have been working on this all day without success so any help would be VERY gratefully received!!</p>
  
  <p>I am using jquery v1.4.4 and jqgrid v3.8.2</p>
  
  <p>Many thanks all</p>
  
  <p>Si</p>