include('includes/db_open.php');
$_SESSION[thiscol]="8e979c";
$title_links = "/ LATEST / ".strtoupper(date('l jS F Y'));
$meta_title = "Topical videos, funny videos, babe videos and more ";
$thiscattitle = "new";
include('includes/header.php');
?>
$nsql = "SELECT * FROM `categories` WHERE `cat_parent_id` = 0 ORDER BY `cat_priority` ASC";
$NRSQ = $db->query($nsql);
$NRS = $db->fetch_array($NRSQ);
while ($NRS!=0) {
$thiscatparent = $NRS[cat_parent_id];
$thiscatid = $NRS[id];
$thiscat = $NRS[cat_shortcut];
$thiscattitle = $NRS[cat_name];
$title_links = "/
".strtoupper($thiscattitle)."";
?>
echo strtoupper($thiscattitle); ?> VIDEOS / LATEST
$asql = "SELECT `video_array` FROM `homepage_videos` WHERE `cat_id` = $NRS[id]";
$ARSQ = $db->query($asql);
$ARS = $db->fetch_array($ARSQ);
if ($ARS!=0) {
$vidarray=explode(",",$ARS[video_array]);
for ($x=0;$x
query($csql);
$CRS = $db->fetch_array($CRSQ);
$lsql = "SELECT `cat_name`,`cat_shortcut` FROM `categories` WHERE `id` = $CRS[video_cat_id]";
$LRSQ = $db->query($lsql);
$LRS = $db->fetch_array($LRSQ);
?>
echo $CRS[video_title]; ?>
}
}
?>
echo strtoupper($thiscattitle); ?> / MORE VIDEOS
$lsql = "SELECT `cat_name`,`cat_shortcut` FROM `categories` WHERE `cat_parent_id` = $thiscatid ORDER BY `cat_views` DESC LIMIT 6";
$LRSQ = $db->query($lsql);
$LRS = $db->fetch_array($LRSQ);
while ($LRS!=0) {
?>
echo ucwords($LRS[cat_name]); ?>
$LRS = $db->fetch_array($LRSQ);
}
?>
$NRS = $db->fetch_array($NRSQ);
}
?>