<?include("header.php");
  
  $sql="SELECT C.category_name, C.category_id, count(V.video_id ) FROM category_master C, video_master V WHERE C.category_status =1 AND V.video_category = C.category_id GROUP  BY category_id ORDER  BY category_name";
  $cmdcat = mysql_query($sql);?>
<h1><strong>All Video Categories</strong>
</h1>

<table width="80%" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <?while ($rscat = mysql_fetch_array($cmdcat))
					{$j=$j+1;?>
    <td height="18"><h1>&nbsp;</h1>
    <p><a href="listing.php?category_id=<?=$rscat["category_id"]?>&category_name=<?=str_replace(" ","_",$rscat["category_name"])?>"><strong>
          <?=$rscat["category_name"]?>
          </strong></a><a href="listing.php?category_id=<?=$rscat["category_id"]?>&category_name=<?=str_replace(" ","_",$rscat["category_name"])?>"><strong> (
            <?=$rscat[2]?>
            ) </strong></a></p></td>
    <?  if ($j==3 || $j==6 || $j==9  || $j==12  || $j==15)
							echo "</tr><tr>";
							
					}?>
  </tr>
</table>

<?include("footer.php");
?>
<script>
	function openWin(argURL, argSize) {
	window.open(argURL, "x_win" + (new Date()).getTime(), "resizable=yes,scrollbars=yes," + argSize);
}
</script>