$page = $_REQUEST['page']; // get the requested page
$limit = $_REQUEST['rows']; // get how many rows we want to have into the grid
$sidx = $_REQUEST['sidx']; // get index row - i.e. user click to sort
$sord = $_REQUEST['sord']; // get the direction
if(!$sidx) $sidx =1;
$examp=1;
// connect to the database
//$db = mysql_connect($dbhost, $dbuser, $dbpassword)
//or die("Connection Error: " . mysql_error());

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

        if ($wh <> ""){
        $result = mysql_query("SELECT COUNT(*) AS count FROM serie a WHERE  ".$wh);
        }else{ $result = mysql_query("SELECT COUNT(*) AS count FROM serie");}
        $row = mysql_fetch_array($result,MYSQL_ASSOC);
        $count = $row['count'];
        if( $count >0 ) {
            $total_pages = ceil($count/$limit);
        } else {
            $total_pages = 0;
        }
        if ($page > $total_pages) $page=$total_pages;
        $start = $limit*$page - $limit; // do not put $limit*($page - 1)
        if ($start<0) $start = 0;
        if ($wh == ""){
        $SQL = "SELECT * FROM serie ORDER BY ".$sidx." ". $sord." LIMIT ".$start." , ".$limit;
        
        } else{
        $SQL = "SELECT * FROM serie WHERE ".$wh." ORDER BY ".$sidx." ". $sord." LIMIT ".$start." , ".$limit;
        }
        $SQL = "SELECT * FROM serie";// ORDER BY ".$sidx." ". $sord." LIMIT ".$start." , ".$limit;
        $result = mysql_query( $SQL ) or die("Couldn t execute query.".mysql_error());

        $responce->page = $page;
        $responce->total = $total_pages;
        $responce->records = $count;
        $i=0;

        while($row = mysql_fetch_array($result,MYSQL_ASSOC)) {
            $responce->rows[$i]['id']=$row[idn];
            $responce->rows[$i]['cell']=array($row[idn],Strip($row[codiceserie]),$row[it],$row[en],$row[fr],$row[es],$row[ru],$row[cancellato]);
           
            $i++;
        }
        echo json_encode($responce);
    
mysql_close($db);

function Strip($value)
{
    if(get_magic_quotes_gpc() != 0)
      {
        if(is_array($value))  
            if ( array_is_associative($value) )
            {
                foreach( $value as $k=>$v)
                    $tmp_val[$k] = stripslashes($v);
                $value = $tmp_val;
            }                
            else  
                for($j = 0; $j < sizeof($value); $j++)
                    $value[$j] = stripslashes($value[$j]);
        else
            $value = stripslashes($value);
    }
    return $value;
}
function array_is_associative ($array)
{
    if ( is_array($array) && ! empty($array) )
    {
        for ( $iterator = count($array) - 1; $iterator; $iterator-- )
        {
            if ( ! array_key_exists($iterator, $array) ) { return true; }
        }
        return ! array_key_exists(0, $array);
    }
    return false;
}

?>