include_once "db.php"; ?>
if(!$_REQUEST[orderby]){$_REQUEST[orderby] = 'c.klasse';} $sql = "SELECT c.klasse, c.cid, count(b.bid) as aantal FROM tblbezoek2 b inner join tblcompetities c on b.bargument = c.cid where b.bpagina = 'rooster' and b.bdatum > '20060915' and c.fk_seizoen = 2 group by c.klasse, c.cid order by $_REQUEST[orderby] $_REQUEST[orderby2]"; if($results = $db->get_results($sql)){ echo "Klasse | Bekeken |
cid&club=0&ft=1\">$r->klasse | $r->aantal |