<?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>
		  <div align="center">
        <!--ADS -->
		<script type="text/javascript"><!--
google_ad_client = "pub-5282993049492367";
google_ad_width = 468;
google_ad_height = 60;
google_ad_format = "468x60_as";
google_ad_type = "text_image";
google_ad_channel ="5926213459";
google_color_border = "F2F2F2";
google_color_link = "FF6600";
google_color_bg = "F2F2F2";
google_color_text = "99C9FF";
google_color_url = "66B5FF";
//--></script>
<script type="text/javascript"
  src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script>
</div>
<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>