How to Print all categories on Homepage

Beginners - Learning PHP
#1

I have a web site. http://www.byfont.com/

The categories appear when we clicked on the tabbed menu “Font Categories”

So,i want to display all the categories on my homepage just above the text “Welcome To Byfont.Com,One Of The …”

The Header page Code is

<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>

<title><?php echo PAGE_NAME; ?> - <?php echo SITE_CONFIG_SITE_NAME; ?></title>

<meta name="description" content="<?php echo PAGE_DESCRIPTION; ?>" />

<meta name="keywords" content="<?php echo PAGE_KEYWORDS; ?>" />

<meta name="copyright" content="Copyright &copy; <?php echo date("Y"); ?> - <?php echo SITE_CONFIG_SITE_NAME; ?>">

<meta name="robots" content="all">

<meta http-equiv="Cache-Control" content="no-cache" />

<meta http-equiv="Expires" content="-1" />

<meta http-equiv="Pragma" content="no-cache" />

    <link rel="alternate" href="http://<?php echo _CONFIG_SITE_FULL_URL; ?>/rss.php" title="Latest Fonts" type="application/rss+xml" />

    <link rel="stylesheet" href="<?php echo SITE_CSS_PATH; ?>/yui_container.css" type="text/css" charset="utf-8" />

    <link rel="stylesheet" href="<?php echo SITE_CSS_PATH; ?>/screen.css" type="text/css" charset="utf-8" />

<!-- Combo-handled YUI JS files: http://developer.yahoo.com/yui/articles/hosting/?animation&button&calendar&connectioncore&container&dom&dragdrop&event&json&paginator&MIN --> 

<script type="text/javascript" src="<?php echo WEB_ROOT; ?>/js/yui_combo.js"></script>

<script>

	<?php echo translate::generateJSLanguageCode(); ?>

</script>

<script src="<?php echo SITE_JS_PATH; ?>/global.js" type="text/javascript"></script>

<script src="<?php echo WEB_ROOT; ?>/js/301a.js" type="text/javascript"></script>

 <script src="<?php echo SITE_JS_PATH; ?>/js/jquery.min.js"></script>

<script src="<?php echo SITE_JS_PATH; ?>/js/jquery.color.js"></script>

<script src="<?php echo SITE_JS_PATH; ?>/js/script.js"></script>

<link rel="shortcut icon" type="image/x-icon" href="favicon.ico">

<a name="pageTop"><!-- --></a>

<div class="mainPageContainer">

	<div class="pageInnerContainer">

	

		<!-- header section -->

		<div class="newheader">

			<!-- main logo -->

			<div>

			<div style="float:left;margin-left:20px;">

<a href="http://www.byfont.com/"><img border="0" src="http://www.byfont.com/Graphics/BF.png" style="boeder:0px"></a>

</div>



				<!-- header ads -->

				<div class="mainHeaderAds">

				<div class="totalfonts">Total Fonts:<?php echo $totalActive = $db->getValue("SELECT COUNT(id) AS total FROM font WHERE status = 'active'"); ?></div>

				<?php echo SITE_CONFIG_ADVERT_TOP_BAR; ?>

				</div>

				

			</div>

		</div>

		<div class="clear"><!-- --></div>

	</div>

</div>

			<label for="searchQuery"><?php echo t("search"); ?></label>

			<input name="q" id="searchQuery" type="text"/>

		</form>


<div class="clear"><!-- --></div>

<div class="mainPageContainer">

	<div class="pageInnerContainer">

		<!-- category section -->

		<a name="categoryBarTop"></a>

		<div id="categoryBar" class="categoryBar" style="display:<?php echo (defined("NO_JS_DISPLAY_CATS")?"block":"none"); ?>;">

			<div id="categoryBarInner" class="categoryBarInner">

				<!-- categories -->

				<?php

					$categories = $db->getRows("SELECT * FROM font_categories ORDER BY categoryName");

					foreach($categories AS $category)

					{

						$catUrl = WEB_ROOT."/c/".$category['id']."/".htmlHelpers::formatForUrl($category['categoryName']);

						echo "<div class='categoryLink' onClick=\"window.location='".$catUrl."';\"><a href='".$catUrl."'>".$category['categoryName']."</a></div>";

					}

				?>

				<div class="clear"><!-- --></div>

			</div>

			<div class="clear"><!-- --></div>

		</div>

		<div class="clear"><!-- --></div>

		

		<!-- browse section -->

		<a name="browseBarTop"></a>

		<div id="browseBar" class="categoryBar" style="display:<?php echo (defined("NO_JS_DISPLAY_BROWSE")?"block":"none"); ?>;">

			<div class="categoryBarInner">

				<!-- letters -->

				<div class="letterListing">

					<?php

						$alphaListArr = array_merge(array('#'), range('A','Z'));

						foreach($alphaListArr AS $alphaItem)

						{

							$letterUrl = WEB_ROOT."/a-z/".($alphaItem=="#"?"num":strtolower($alphaItem));

							echo "<div class='letterLink' onClick=\"window.location='".$letterUrl."';\"><a href='".$letterUrl."'>".$alphaItem."</a></div>";

						}

					?>

					<div class="clear"><!-- --></div>

				</div>

			</div>

			<div class="clear"><!-- --></div>

		</div>

		<div class="clear"><!-- --></div>

		

		<!-- custom preview section -->

		<a name="settingsBarTop"></a>

		<div id="settingsBar" class="settingsBar" style="display:none;">

			<div class="categoryBarInner">

				<!-- options -->

				<div class="customPreviewSettings">

					<form method="GET" action="<?php echo WEB_ROOT; ?>" id="customPreviewForm" name="customPreviewForm" onSubmit="updateCustomPreview(); return false;">

						<div class="customPreviewTextLabel">

							<label for="customPreviewText">

								<?php echo t("custom_preview_text"); ?>

							</label>

						</div>

						<div class="customPreviewTextInput">

							<input name="customPreviewText" id="customPreviewText" type="text" value="<?php echo htmlentities($_SESSION['customPreviewText'], ENT_COMPAT, "UTF-8"); ?>"/>

						</div>

						<div class="customPreviewTextColourLabel">

							<label for="customPreviewTextColour">

								<?php echo t("text_colour"); ?>

							</label>

						</div>

						<div class="customPreviewTextColourPicker">

							<div id="colorpicker301" class="colorpicker301"></div>

							<input name="customPreviewTextColour" value="<?php echo $customPreviewTextColour?"#".$customPreviewTextColour:""; ?>" type="text" id="customPreviewTextColour" size="6">

							<span id="span1" class='colourPickerBox' title="Click to choose a background colour." style="border:1px solid #999999; background-color:#<?php echo htmlentities($_SESSION['customPreviewTextColour']); ?>; cursor:pointer;" onClick="javascript:showColorGrid3('customPreviewTextColour','span1');">&nbsp;&nbsp;&nbsp;&nbsp;</span>

						</div>

						<div class="customPreviewTextSubmit">

							<input name="submitPreviewSettings" id="submitPreviewSettings" type="submit" value="<?php echo t("update"); ?>"/>

						</div>

					</form>

					<div class="clear"><!-- --></div>

				</div>

			</div>

			<div class="clear"><!-- --></div>

		</div>

		<div class="clear"><!-- --></div>

		

		<!-- body section -->

		<div class="bodyBarWrapper">

			<div class="mainPageContainer">

			

				<!-- there's just some things which are easier with tables!... -->

				<table width="100%" cellspacing="0" cellpadding="0">

					<tr>

				

						<?php if(strlen(SITE_CONFIG_ADVERT_LEFT_VERTICAL_BAR)): ?>

							<!-- header ads -->

							<td>

								<div class="leftPageAds">

									<?php echo SITE_CONFIG_ADVERT_LEFT_VERTICAL_BAR; ?>

								</div>

							</td>

						<?php endif; ?>



						<td style="width:100%;">

							<div class="mainPageContent">
Sponsor our Newsletter | Privacy Policy | Terms of Service