Flexigrid - Lightweight but rich data grid

[eluser]Unknown[/eluser]
Paulo, amazing work. You have been all over the social sites and i recently ditched phpGrid for your much nicer javascript code.

Im an odd ball using PHP5 + MS SQL 2000 + Flexigrid. Im having some issues where the flexigrid control will error out when paging through the data or during certain sorting operations. I can't seem to pin point my issue. I was wondering if there are any debug options. Id really love to see the actual query that my PHP JSON script is executing during the ajax requests, but im just not sure how to do so. Here is my PHP JSON script (hacked from yours)

Code:

<?

include '../classes/class.mssql.php'; //this class works fine.

$page       = $_POST['page'];
$rp         = $_POST['rp'];
$sortname   = $_POST['sortname'];
$sortorder  = $_POST['sortorder'];
$name       = $_POST['name'];

$fields = " ID,Name,State,Phone ";
$table = " tbl ";
$pk = " ID ";

if (!$sortname)             $sortname   = 'ID';
if (!$sortorder)            $sortorder  = ' DESC ';
if ($sortorder == 'DESC')   $osort      = ' ASC ';

if($_REQUEST['query'] != ""){
    $where  = $_REQUEST['qtype']." LIKE '%".$_REQUEST['query']."%' ";
    $where2 = " WHERE " .$_REQUEST['qtype']." LIKE '%".$_REQUEST['query']."%' ";
    $where3 = " AND " .$_REQUEST['qtype']." LIKE '%".$_REQUEST['query']."%' ";
}
else {
    $where  = "";
    $where2 = "";
    $where3 = "";
}

$sort = "ORDER BY $sortname $sortorder";

if (!$page) $page   = 1;
if (!$rp)   $rp     = 15;

if ( (($page-1) * $rp) == 0 ) {
    $start = $rp;
}
else {
    $start = (($page-1) * $rp);
}

$db = new DB();
$db->connect();

$db->query("SELECT COUNT(ID) AS [count] FROM $table $where2");
$db->fetchRow();
$total = $db->record['count'];

header("Expires: Aug, 04 Aug 1980 05:00:00 GMT" );
header("Last-Modified: " . gmdate( "D, d M Y H:i:s" ) . "GMT" );
header("Cache-Control: no-cache, must-revalidate" );
header("Pragma: no-cache" );
header("Content-type: text/x-json");

$json = "";
$json .= "{\n";
$json .= "page: $page,\n";
$json .= "total: $total,\n";
$json .= "rows: [";

$rc = false;

$sql = "SELECT TOP $rp $fields FROM $table WHERE $pk NOT IN (SELECT $pk FROM (SELECT TOP $start $fields FROM $table $where2 $sort) as [tbl1]) $where3 $sort";

$db->query($sql);

while ($db->fetchRow()) {
    if ($rc) $json .= ",";
    $json .= "\n{";
    $json .= "id:'".$db->record['ID']."',";
    $json .= "cell:['<a id=".record['ID'].">".$db->record['ID']."</a>','".$db->record['Name']."','".addslashes($db->record['State'])."','".addslashes($db->record['Phone'])."']";
    $json .= "}";
    $rc = true;
    //please note the anchor tag above is syntactically correct, dunno why the BBS is not taking my code, but that's NOT and issue thanks.
}

$json .= "]\n";
$json .= "}";

echo $json;

$db->disconnect();

?&gt;