query(" select szSvcName as name, count(*) as cnt from devchannel join device using (did) where device.last > now() - interval 30 day group by 1 having count(*) > 8 order by 1 "); $i = 0; print ""; while (($data = $ret->fetch_assoc())) { $chan = $data['name']; $cnt = $data['cnt']; if ($chan == "Unknown") continue; print ""; if ($i++ > 7) { $i = 0; print ""; } } print "
$chan
"; print ""; print depg::channelicon($chan, 80); print ""; print "
"; ?>