=#$tDate2Last# GROUP BY DateAdd('h',nHour,dDate) ORDER BY 1"); FetchRow($Sql); odbc_do($Db,"Update tDate2 Set nFreq=$nFreq Where aDate=#$aDate#"); if ($aDate): while (FetchRow($Sql)): @odbc_do($Db,"Insert Into tDate2 (aDate, nFreq) Values (#$aDate#, $nFreq)"); endwhile; odbc_do($Db,"Update tParam Set cValue='$aDate' Where cName='tDate2Last'"); endif; ?>

Visitors' Histogram

Number of Visitors by Month
$bDate

"; ?>
=DateSerial(Year(Now),Month(Now),1) Order By bDate"; $Sql = odbc_do($Db,$sq); while (FetchRow($Sql)){ if (ereg('11',$eDate) or ereg('21',$eDate)){ echo "
This
month		DayVisitors
" . '		' . ''; } echo "" . ""; } $Sql = odbc_do($Db,"Select Max(nfreqs) as aMax,Sum(nfreqs) as aSum From vHitsMonth"); FetchRow($Sql); $Sql = odbc_do($Db,"Select cMonth, nfreqs From vHitsMonth Order By 1 DESC"); FetchRow($Sql); echo "" . "
This
month		DayVisitors
 $eDate $cDay" . NBSP(number_format($nFreqs)) . "
Total " . NBSP(number_format($nfreqs)) . "
"; ?>

"; echo ""; while (FetchRow($Sql)) { echo ""; echo ""; echo ""; } echo "" . ""; ?>
MonthHistogramVisitors
  "; echo " " . number_format($nfreqs) . " 
 " . substr($cMonth,-9) . "  " . number_format($nfreqs) . " 
Total " . number_format($aSum) . "