home *** CD-ROM | disk | FTP | other *** search
/ Chip 2004 October / CMCD1004.ISO / Software / Shareware / Programare / cnstats / reports / system.php < prev    next >
Encoding:
PHP Script  |  2004-06-19  |  619 b   |  21 lines
  1. <?php
  2. $inpage=40;
  3.  
  4. $filter=$HTTP_GET_VARS["filter"];
  5.  
  6. $DATELINK="&filter=".urlencode($filter);
  7.  
  8. $sqlflt=GenerateFilter($filter);
  9. $r=cnstats_sql_query("select agent,count(agent) from cns_log WHERE date>'".$startdate."' AND date<'".$enddate."' ".$sqlflt." group by agent order by 2 desc");
  10.  
  11. $count=mysql_num_rows($r);
  12. if ($start+$inpage>$count) $finish=$count; else $finish=$start+$inpage;
  13. for ($i=$start;$i<$finish;$i++) {
  14.     $TABLED[]=mysql_result($r,$i,0);
  15.     $TABLEC[]=mysql_result($r,$i,1);
  16.     }
  17.  
  18. LeftRight($start,$inpage,$num,$count,0);
  19. ShowTable($start);
  20. LeftRight($start,$inpage,$num,$count);
  21. ?>