include('includes/db_open.php');
$_SESSION[thiscol]="8e979c";
$letters="a,b,c,d,e,f,g,h,i,j,k,l,m,n,o,p,q,r,s,t,u,v,w,x,y,z";
$letlist=explode(",",$letters);
$numletters=sizeof($letlist);
$meta_title="Movie categories beginning with '".strtoupper($_GET[l])."'";
include('includes/header.php');
?>
echo strtoupper($meta_title); ?>
$count_sql = "SELECT COUNT(*) AS `num_records` FROM `categories` WHERE `cat_name` LIKE '$_GET[l]%'";
$CRSQ = $db->query($count_sql);
$CRS = $db->fetch_array($CRSQ);
$total_records = $CRS[num_records];
$qtr=round(($total_records/4),0);
$csql = "SELECT * FROM `categories` WHERE `cat_name` LIKE '$_GET[l]%' ORDER BY `cat_name` ASC";
$CRSQ = $db->query($csql);
$CRS = $db->fetch_array($CRSQ);
$x=0;
while ($CRS!=0) {
?>
- echo $CRS[cat_name]; ?>
$x++;
if ($x==$qtr || $x==($qtr*2) || $x==($qtr*3)) {
?>
}
$CRS = $db->fetch_array($CRSQ);
}
?>
MOST POPULAR VIDEOS ON echo strtoupper($_SESSION['sitename']); ?>/ RIGHT NOW
include('includes/footer.php'); ?>