$page = $_GET['page'];
$limit = $_GET['rows'];
$sidx = $_GET['sidx'];                 
$sord = $_GET['sord'];

$query ="select a.store,max(a.date)as dats from receipt a group by a.store order by :sidx :sord limit :start, :limit";
MyLog($query);
$STH = $db->prepare($query);
$STH->bindParam(':sidx',$sidx);
$STH->bindParam(':sord',$sord);
$STH->bindParam(':start',$start);
$STH->bindParam(':limit',$limit);
$STH->execute();  

$STH->bindValue(':start', $start, PDO::PARAM_INT);
$STH->bindParam(':limit',$limit, PDO::PARAM_INT);

$query ="select a.store,max(a.date)as dats from receipt a group by a.store order by :sidx :sord limit ".$start." , ". $limit;

$STH->bindParam(':sidx',$sidx);
$STH->bindParam(':sord',$sord);
MyLog('Тип start='.gettype($start));
MyLog('Тип limit='.gettype($limit));
$limit=$limit+1-1;
MyLog('Тип limit='.gettype($limit));
$STH->bindValue(':start',(int) $start, PDO::PARAM_INT);
$STH->bindValue(':limit',(int) $limit, PDO::PARAM_INT);
$STH->execute(); 

Тип start=integer
Тип limit=string
Тип limit=integer

...MySQL server version for the right syntax to use near '10' at line 1' in C....

$query ="select a.store,a.date as dats, sum(a.totalrub) as itogo from receipt a 
where sum(a.totalrub) < :PLANS group by a.store, a.date order by :sidx :sord limit :start, :limit";

select sel.* from (select a.store,DATE(a.`date`),sum(a.`amount`) as ITOGO from receipt a
group by a.store,DATE(a.date) limit 100) sel where sel.itogo<:PLANS

select a.store,DATE(a.`date`) as dt,sum(a.`amount`) as ITOGO from receipt a
where DATE(a.`date`)>"2013-09-10"
group by a.store,DATE(a.date) having sum(a.`amount`)<100000 limit 1000

...having sum(a.`amount`)<:PLANS

...having sum(a.`amount`)<'100000'

...having sum(a.`amount`)<100000