jQuery Grid Plugin - jqGrid

Hi 

I have set up JQgrid i have the regular single search working, but the advanced toolbar and and multisearch will not work. I am able to pull up the functions and see them but they filter no results. I have even seen in firebug when it searchs it is sending the right request but puls back all data. Im sure im missing something in my server code but struggled to see what it is. 

jQuery(document).ready(function(){

jQuery("#list").jqGrid({

url:'serverjson.php',

datatype: "json",

mtype: 'GET',

colNames:['id','Date', 'Name','Address 1','Address 2','City','Province','Postal','Gender','Phone','Value Card','Sharps','Fresh','Comments','Email','Manager','Domain'],

colModel:[

{name:'CUSTOMER_ID', index:'CUSTOMER_ID', width:55, align:'center',

searchoptions:{sopt:['eq','ne','lt','le','gt','ge','bw','ew','cn','nc']},

editable:false},

{name:'DATE_ENTERED', index:'DATE_ENTERED', width: 90, align:'center',

searchoptions:{sopt:['eq','ne','lt','le','gt','ge','bw','ew','cn','nc']},

editable:false},

{name:'NAME', index:'NAME', width: 250, align:'left',

searchoptions:{sopt:['eq','ne','lt','le','gt','ge','bw','ew','cn','nc']},

editable:true},

{name:'ADDRESS1', index:'ADDRESS1', width:150, align:'center',

searchoptions:{sopt:['eq','ne','lt','le','gt','ge','bw','ew','cn','nc']},

editable:true},

{name:'ADDRESS2', index:'ADDRESS2', width:150, align:'center',

searchoptions:{sopt:['eq','ne','lt','le','gt','ge','bw','ew','cn','nc']},

editable:true},

{name:'CITY', index:'CITY', width:150, align:'center',

searchoptions:{sopt:['eq','ne','lt','le','gt','ge','bw','ew','cn','nc']},

editable:true},

{name:'PROVINCE', index:'PROVINCE', width:80, align:'center',

searchoptions:{sopt:['eq','ne','lt','le','gt','ge','bw','ew','cn','nc']},

editable:true},

{name:'POSTAL', index:'POSTAL', width:120, align:'center',

searchoptions:{sopt:['eq','ne','lt','le','gt','ge','bw','ew','cn','nc']},

editable:true},

{name:'GENDER', index:'GENDER', width:80, align:'center',

searchoptions:{sopt:['eq','ne','lt','le','gt','ge','bw','ew','cn','nc']},

editable:true},

{name:'PHONE', index:'PHONE', width:80, align:'center',

searchoptions:{sopt:['eq','ne','lt','le','gt','ge','bw','ew','cn','nc']},

editable:true},

{name:'CUSTOMER_NUMBER', index:'CUSTOMER_NUMBER', width:80, align:'center',

searchoptions:{sopt:['eq','ne','lt','le','gt','ge','bw','ew','cn','nc']},

editable:true},

{name:'SHARPS', index:'SHARPS', width:80, align:'center',

searchoptions:{sopt:['eq','ne','lt','le','gt','ge','bw','ew','cn','nc']},

editable:true},

{name:'FRESH', index:'FRESH', width:80, align:'center',

searchoptions:{sopt:['eq','ne','lt','le','gt','ge','bw','ew','cn','nc']},

editable:true},

{name:'COMMENTS', index:'COMMENTS', width:80, align:'center',

searchoptions:{sopt:['eq','ne','lt','le','gt','ge','bw','ew','cn','nc']},

editable:true},

{name:'EMAIL', index:'EMAIL', width:80, align:'center',

searchoptions:{sopt:['eq','ne','lt','le','gt','ge','bw','ew','cn','nc']},

editable:true},

{name:'MANAGER', index:'MANAGER', width:80, align:'center',

searchoptions:{sopt:['eq','ne','lt','le','gt','ge','bw','ew','cn','nc']},

editable:true},

{name:'DOMAIN', index:'DOMAIN', width:150, align:'left',

searchoptions:{sopt:['eq','ne','lt','le','gt','ge','bw','ew','cn','nc']},

editable:true},

],

rowNum: 10,

rowList:[10,20,30],

loadonce: false,

gridview:true,

height: "100%",

pager: '#pager',

sortname: 'CUSTOMER_ID',

viewrecords: true,

sortorder: "asc",

caption:"- Customer Details",

editurl:"server3.php",

pagination: true,

shrinktofit:false,

width:"960",

});

jQuery("#list").jgrid = {

search : {

caption: "Search...",

Find: "Find",

Reset: "Reset",

odata : ['equal', 'not equal', 'less', 'less or equal','greater','greater or equal', 'begins with','does not begin with','is in','is not in','ends with','does not end with','contains','does not contain'],

groupOps: [ { op: "AND", text: "all" }, { op: "OR", text: "any" } ],

matchText: " match",

rulesText: " rules"

}},

jQuery("#list").jqGrid('navGrid','#pager',{ view: true, del: false, add: true, edit: true },

{}, // default settings for edit

{}, // default settings for add

{}, // delete

{closeOnEscape: true, multipleSearch: false ,

closeAfterSearch: true }, // search options

{}

);

//jQuery("#list").jqGrid('filterToolbar', {stringResult: true, searchOnEnter: false, defaultSearch:"eq"});

});

Server Code:

<?php

// database connection information is stored here

include("dbconfig.php");

// The first four variables retrieve parameters for

// table creation. (Some for searching also.)

$page = $_REQUEST['page']; // requested page

$limit = $_REQUEST['rows']; // rows per page

$sidx = $_REQUEST['sidx']; // index row

$sord = $_REQUEST['sord']; // sorting order

// if index isn't passed then use the first column

if(!$sidx) $sidx=1;

// these three variables are used to search for records

$where = $_REQUEST['searchField']; // field to be searched

$whereValue = $_REQUEST['searchString']; // value to be looked for

$whereOper = $_REQUEST['searchOper']; // operator used

// If $whereOper was passed then cofigure the SQL operator

// and what we are searching for. There are a couple of

// these remarked out because honestly I do not know the mySQL

// syntax and I really don't need it for this project.

if ($whereOper <> NULL) {

switch($whereOper){

case("eq"):

$sqlOperator = " = ";

$whereValue = "'".$whereValue."'";

break;

case("ne"):

$sqlOperator = " <> ";

$whereValue = "'".$whereValue."'";

break;

case("lt"):

$sqlOperator = " < ";

$whereValue = "'".$whereValue."'";

break;

case("le"):

$sqlOperator = " <= ";

$whereValue = "'".$whereValue."'";

break;

case("gt"):

$sqlOperator = " > ";

$whereValue = "'".$whereValue."'";

break;

case("ge"):

$sqlOperator = " >= ";

$whereValue = "'".$whereValue."'";

break;

case("bw"):

$sqlOperator = " REGEXP '^";

$whereValue = $whereValue."'" ;

break;

// case("bn"):

// $sqlOperator = "=";

// $whereValue = "'".$whereValue."'";

// break;

// case("in"):

// $sqlOperator = "=";

// $whereValue = "'".$whereValue."'";

// break;

// case("ni"):

// $sqlOperator = "=";

// $whereValue = $whereValue."'";

// break;

case("ew"):

$sqlOperator = " LIKE '%";

$whereValue = $whereValue."'";

break;

// case("en"):

// $sqlOperator = "=";

// $whereValue = "'".$whereValue."'";

// break;

case("cn"):

$sqlOperator = " LIKE '%";

$whereValue = $whereValue."%'";

break;

case("nc"):

$sqlOperator = " NOT LIKE '%";

$whereValue = $whereValue."%'";

break;

}

}

// Connect to the MySQL database server

$db = mysql_connect($dbhost, $dbuser, $dbpassword) or die("Connection Error: " . mysql_error());

// Select the database

mysql_select_db($database) or die("Error connecting to db.");

// if $where is not NULL then get the count on the search criteria,

// else get the count on everything.

if ($where <> NULL){

$result = mysql_query("SELECT COUNT(*) AS count FROM CUSTOMER WHERE ".$where.$sqlOperator.$whereValue);

} else {

$result = mysql_query("SELECT COUNT(*) AS count FROM CUSTOMER");

}

// Calculate the number of rows for the query.

// This is used for paging the result.

$row = mysql_fetch_array($result, MYSQL_ASSOC);

$count = $row['count'];

// calculate the total pages for the query

if($count > 0) {

$total_pages = ceil($count/$limit);

} else {

$total_pages = 0;

}

// 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 < 0) $start = 0;

// if where is not null then retrieve requested rows based on search

// else retrieve everything

if ($where <> NULL) {

$SQL = "SELECT CUSTOMER_ID, DATE_ENTERED, NAME, ADDRESS1, ADDRESS2, CITY, PROVINCE, POSTAL, GENDER, PHONE, CUSTOMER_NUMBER, SHARPS, FRESH, COMMENTS, EMAIL, MANAGER, DOMAIN FROM CUSTOMER WHERE ".$where.$sqlOperator.$whereValue." ORDER BY ".$sidx." ".$sord." LIMIT ".$start." , ".$limit;

$result = mysql_query($SQL) or die("Could not execute query ".$SQL." ".mysql_error());

} else {

$SQL = "SELECT CUSTOMER_ID, DATE_ENTERED, NAME, ADDRESS1, ADDRESS2, CITY, PROVINCE, POSTAL, GENDER, PHONE, CUSTOMER_NUMBER, SHARPS, FRESH, COMMENTS, EMAIL, MANAGER, DOMAIN FROM CUSTOMER ORDER BY ".$sidx." ".$sord." LIMIT ".$start." , ".$limit;

$result = mysql_query($SQL) or die("Could not execute query. ".mysql_error());

}

// echo $SQL . "<br />";

// response back to web page

$response->page = $page;

$response->total = $total_pages;

$response->records = $count;

$i=0;

while($row = mysql_fetch_array($result,MYSQL_ASSOC)) {

$response->rows[$i]['id']=$row[CUSTOMER_ID];

$response->rows[$i]['cell']=array($row[CUSTOMER_ID], $row[DATE_ENTERED], $row[NAME], $row[ADDRESS1], $row[ADDRESS2],

$row[CITY], $row[PROVINCE], $row[POSTAL], $row[GENDER], $row[PHONE],$row[CUSTOMER_NUMBER],$row[SHARPS],$row[FRESH],$row[COMMENTS],$row[EMAIL],$row[MANAGER], $row[DOMAIN]);

$i++;

}

echo json_encode($response);

mysql_close($db);

?>

Thanks in advance