<?php
	$s=tmq("select * from cate where 1 order by ordr ");
		
		?><TABLE width=100% border=0>

		<TR>
			<TD align=center class=umnhead><A >เลือกดูตามหมวดหมู่</A></TD>
		</TR>
		<TR>
			<TD class=umnsub><?
		$sprechk=tmq("select * from cate where 1 order by ordr ");
		$thiscc=0;
		while ($prechkr=tmq_fetch_array($sprechk)) {		
					$prechks2=tmq("select * from cate_sub where pid='$r[id]'  ");
					$thiscc+=tmq_num_rows($prechks2);
		}
		if ($prechks2>0) {
		while ($r=tmq_fetch_array($s)) {
			?><div ID='bigcatecover<? echo $r[id]?>' ><B style="color:black"><?
			echo ("<img src='./neoimg/collectionicon/$r[icon]' width=24 align=texttop> ".getlang($r[name]));;
			$s2=tmq("select * from cate_sub where pid='$r[id]' order by name ");
			
			?></B><TABLE  width=100% border=0 >
			<TR>
				<TD style="padding-left: 10"><?
			$countdisplayedsub=0;
			while ($r2=tmq_fetch_array($s2)) {
				$cc="select id from media where cate='$r2[id]' ";
			if ($acadtoviewLIMIT!="") {
				$cc.=" $acadtoviewLIMIT ";
			}
			$cc=tmq($cc);
			if (tmq_num_rows($cc)!=0) {
				$countdisplayedsub++;
				?><TABLE  width=100% border=0 cellpadding=0 cellspacing=0 style="float:left"
					onmouseover="this.style.backgroundColor='#DADDE7' "
					onmouseout="this.style.backgroundColor='transparent';">
				<TR>
					<TD align=left><A HREF="index.php?mode=viewcategory&cateid=<?echo $r2[id]?>">
					<FONT SIZE="" COLOR="black" class=smaller2><?
				echo ("<img src='./neoimg/collectionicon/$r2[icon]' width=16 align=left border=0> ");
				echo " ".getlang($r2[name]);;
				//show_mediaicon($r[randid]);
				echo "<BR><nobr><FONT class=smaller2 style='color: black'> (<B class=smaller2>".number_format(tmq_num_rows($cc))."</B> รายการ)</FONT></nobr>";
				?></FONT></A></TD>
				</TR>
				</TABLE><?
				}

				}
				if ($countdisplayedsub==0) {
					?><style> #bigcatecover<? echo $r[id]?> { display:none;}</style><?
					echo "<FONT COLOR=$fontcolor class=smaller2>-</FONT>";
				}
			?></TD>
			</TR>
			</TABLE></div><?//div end bigcatecover

		}

		}
		?></TD>
		</TR>
		</TABLE><?
?>