<?php
$page = $_GET['page']; // get the requested page
$limit =$_GET['rows'];; // get how many rows we want to have into the grid
$sidx = $_GET['sidx']; // get index row - i.e. user click to sort
$sord = $_GET['sord']; // get the direction
if(!$sidx) $sidx =1;
// connect to the database
mysql_connect('localhost', 'root', '')or die("Connection Error: " . mysql_error());
mysql_select_db('order_zpp');
$result = mysql_query('SELECT COUNT(*) AS count FROM `tovar` INNER JOIN `_order` ON (`tovar`.`id_tovar` = `_order`.`id_tovar`)');
$row = mysql_fetch_array($result,MYSQL_ASSOC);
$count = $row['count'];

if( $count > 0 && $limit > 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)
$SQL = "SELECT 
  `_order`.reg_num,
  `_order`.data_reg,
  `_order`.commerce_name,
  tovar.tovar_name,
  `_order`.srokdeyst_ceni,
  `_order`.id_order
FROM
  tovar
  INNER JOIN `_order` ON (tovar.id_tovar = `_order`.id_tovar) ORDER BY ".$sidx." ".$sord." LIMIT ".$start.", ".$limit; 
$result = mysql_query( $SQL ) or die("Couldnot execute query.".mysql_error());

if ( stristr($_SERVER["HTTP_ACCEPT"],"application/xhtml+xml") ) {
header("Content-type: application/xhtml+xml;charset=windows-1251"); } else {
header("Content-type: text/xml;charset=windows-1251"); 
}
$et = ">";

echo "<?xml version='1.0' encoding='utf-8'?$et\n";
echo "<rows>";
echo "<page>".$page."</page>";
echo "<total>".$total_pages."</total>";
echo "<records>".$count."</records>";
// be sure to put text data in CDATA
while($row = mysql_fetch_array($result,MYSQL_ASSOC)) {
	echo "<row id='". $row[id]."'>";			
	echo "<cell><![CDATA[". $row[reg_num]."]]></cell>";
	echo "<cell>". $row[data_reg]."</cell>";
	echo "<cell><![CDATA[". $row[commerce_name]."]]></cell>";
	echo "<cell>". $row[srokdeyst_ceni]."</cell>";
	echo "<cell><![CDATA[". $row[tovar_name]."]]></cell>";
	echo "</row>";
}
echo "</rows>";	
?>

$result = mysql_query('SELECT * FROM `tovar` INNER JOIN `_order` ON `tovar`.`id_tovar` = `_order`.`id_tovar`');
$count = mysql_num_rows($result);
if( $count > 0 && $limit > 0) {.....

$limit =$_GET['rows'];; 

mysql_query('SELECT COUNT(*) AS count FROM `tovar` INNER JOIN `_order` ON (`tovar`.`id_tovar` = `_order`.`id_tovar`)')