|
|
 |
 |
|
select_min ( TN_CATEGORY, $TF_CATEGORY[0], $condition = "", $show = 0 );
}
//Get categories
$orderBy = " ORDER BY ".$TF_CATEGORY[3];
$result = $sq->select (TN_CATEGORY, " * ", "", $orderBy, 0 );
while ($row = mysql_fetch_row ( $result ) ){
$dbcatId = $row[0];
$dbcatName = ucwords( $row[1] );
$imgName = "";
if ( $dbcatId == $catId ){
$dbcatDesc = html_entity_decode ($row[2]);
$className = "menucolor" ;
$imgName = "minus.gif";
}else{
$className = "menu";
$imgName = "plus.gif";
}
echo " | ";
$catLink = "products.php?catid=".$dbcatId;
echo "";
echo "";
echo "";
echo "![](images/".$imgName.") ";
echo "" ;
echo " | ";
echo " | ";
echo " ";
//Show subcat for the menu which is highlighted
if ( $className == "menucolor") {
//Get subcategories
$orderBy = " ORDER BY ".$TF_SUBCATEGORY[3];
$resultSubCat = $sq->select (TN_SUBCATEGORY, " * ", $TF_SUBCATEGORY[2]."=".$catId, $orderBy, 0 );
while ($rowSubCat = mysql_fetch_row ( $resultSubCat ) ){
$dbsubCatId = $rowSubCat[0];
$dbsubCatName = ucwords( $rowSubCat[1] );
echo "";
} //end of inner while
}
}
?>
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
";
echo "
