"; ?> \n"; $showCat .= "
"; //$showCat .= "  "; $showCat .= "

"; $showCat .=" "; $showCat .="
"; } else if ($catCount%$colMax ==0) { $showCat .=""; echo $showCat; echo "\n".$showTopics."\n \n"; $showCat ="\n"; $showTopics =""; $catCount=0; } $showCat .= "".$catName['catName']."\n"; $showTopics .=$hasTopics; } } $catCount++; echo $showCat; if (($catCount%$colMax)!=0) { echo " \n"; } echo "\n"; echo $showTopics; if (($catCount%5)!=0) { echo " \n"; } echo "\n \n"; echo "\n"; if (@include(getenv('DOCUMENT_ROOT').'/adserver/phpadsnew.inc.php')) { if (!isset($phpAds_context)) $phpAds_context = array(); $phpAds_raw = view_raw ('zone:15', 0, '', '', '0', $phpAds_context); $phpAds_context[] = array('!=' => 'bannerid:'.$phpAds_raw['bannerid']); $phpAds_context[] = array('!=' => 'campaignid:'.$phpAds_raw['campaignid']); echo $phpAds_raw['html']; } echo ""; echo " "; echo " "; echo " "; echo " "; echo " "; echo ""; function getCats($catID) { global $database_featured; global $featured; if ($catID ==0){ mysql_select_db($database_featured, $featured); $query_categories = "SELECT * FROM tblcategories WHERE catStatus = 1 ORDER BY displayOrder ASC"; $categories = mysql_query($query_categories, $featured) or die(mysql_error()); } else { mysql_select_db($database_featured, $featured); $query_categories = "SELECT * FROM tblcategories WHERE catID =".$catID; $categories = mysql_query($query_categories, $featured) or die(mysql_error()); } return $categories; } //end getCats function getTopics($catID) { global $database_featured; global $featured; mysql_select_db($database_featured, $featured); $query_topics = "select * from tbltopics join jcattopics on fk_TopicID = topicID and fk_catID =". $catID." where topicStatus=1 order by DateAdded desc, topicName asc"; $topics = mysql_query($query_topics, $featured) or die(mysql_error()); $topicList = ""; $topicCount=0; while($topicName = mysql_fetch_array($topics)) { $topicCount++; if ($topicCount==1) { $topicList .= "\n 
"; } else { //$topicList.= " ".$topicName['topicName']."
"; $topicList.= " 
"; } } if ($topicCount ==0) { $topicList = "none"; } else { $topicList .="\n"; } mysql_free_result($topics); return $topicList; } // end getTopics ?>