for ($x = 1; $x <= 29; $x++)
{
$SQLstringx=QueryDBSumV('tbl'.$depttable[$x],$from,$to);
$queryx = mysql_query($SQLstringx) or die("Fatal error: ".error_reporting(0));
$count = mysql_num_rows(mysql_query($SQLstringx));
if ($count > 0) {
$setx=array();
while ($recordx = mysql_fetch_object($queryx)) {
$setx[$recordx->starperiod][]= $recordx;
}
ksort($setx);
$headeralloc=array();
$headerutil=array();
$headerproj=array();
$headeract=array();
foreach ($setx as $headerkey=> $headervalue) {
foreach ($headervalue as $headerrecords) {
$mono=$headerrecords->qrtcode;
$sno= remove_non_numeric($mono);
$monumber=substr($sno,0,-4);
$headeralloc[$monumber]=$headerrecords->sumtotalalloc;
$headerutil[$monumber]=$headerrecords->sumtotalutil;
$headerproj[$monumber]=$headerrecords->sumtotalip;
$headeract[$monumber]=$headerrecords->sumtotalia;
}
}
print_r($headeralloc);
}
}