<?php
	$s=tmq("select * from cate where 1 order by ordr ");
		
		?><TABLE width=100%  border=0 cellpadding=0 cellspacing=0>
		<TR>
			<TD><?
		while ($r=tmq_fetch_array($s)) {
			?><A name="maincateid<? echo $r[id]?>"></A><?
			echo index_sepper("<img src='./neoimg/collectionicon/$r[icon]' width=16 align=texttop> ".getlang($r[name]));;
			$s2=tmq("select * from cate_sub where pid='$r[id]' order by name ");
			
			?><TABLE  width=100% border=0  class=mediabox cellpadding=0 cellspacing=0>
			<TR>
				<TD style="padding-left: 60"><?
			while ($r2=tmq_fetch_array($s2)) {
				$cc="select id from media where cate='$r2[id]' ";
			if ($acadtoviewLIMIT!="") {
				$cc.=" $acadtoviewLIMIT  ";
			}
			$cc=tmq($cc)
				?><TABLE  width=150 border=0 style="float:left"
				<?if (tmq_num_rows($cc)!=0) {	?>
					onmouseover="this.style.backgroundColor='#ECF5FF';"
					onmouseout="this.style.backgroundColor='transparent';"		
				<?}?>>
				<TR>
					<TD align=center><?
				if (tmq_num_rows($cc)!=0) {		
					?><A HREF="index.php?mode=viewcategory&cateid=<?echo $r2[id]?>"><?
				}
				?><FONT SIZE="" COLOR="white"><?
				echo "<img src='./neoimg/collectionicon/$r2[icon]' width=32 align=texttop border=0 ";
				if (tmq_num_rows($cc)==0) {		
					echo " style=\"Filter: Gray\" ";
				}
				echo "> ";
				echo "<BR><FONT class=smaller2 style='height:28; color: #184692; font-size: 18;'>".getlang($r2[name])."</FONT>";;
				//show_mediaicon($r[randid]);
				echo "<BR><nobr><FONT class=smaller2 style='color: 666666'> (".number_format(tmq_num_rows($cc))." รายการ)</FONT></nobr>";
				?></FONT></A></TD>
				</TR>
				</TABLE><?
			}
			?></TD>
			</TR>
			</TABLE><?
		}
		?></TD>
		</TR>
		</TABLE><?
?>