function zen_get_subcategoriesarray(&$subcategories_array, $parent_id = 0) { global $db; $subcategories_query = "SELECT c.`categories_id`,cd.`categories_name`\n FROM " . TABLE_CATEGORIES . " c ," . TABLE_CATEGORIES_DESCRIPTION . " cd\n WHERE cd.`language_id` = {$_SESSION['languages_id']} AND c.`categories_id` = cd.`categories_id` AND c.`parent_id` = '" . (int) $parent_id . "'"; $subcategories = $db->Execute($subcategories_query); while (!$subcategories->EOF) { $num = count($subcategories_array); $subcategories_array[$num] = array('categories_id' => $subcategories->fields['categories_id'], 'categories_name' => $subcategories->fields['categories_name']); $subcategories->MoveNext(); } $subcategories->Move(0); while (!$subcategories->EOF) { if ($subcategories->fields['categories_id'] != $parent_id and zen_has_category_subcategories($subcategories->fields['categories_id'])) { zen_get_subcategoriesarray($subcategories_array, $subcategories->fields['categories_id']); } $subcategories->MoveNext(); } }
<?php $display_num = 12; $subCategoriesArray = array(); if (isset($_GET['products_id'])) { $relatedCategoriesParentId = zen_get_products_category_id($_GET['products_id']); $relatedCategoriesId = zen_get_categories_parent_id($relatedCategoriesParentId); zen_get_subcategoriesarray($subCategoriesArray, $relatedCategoriesId); } else { if (isset($current_category_id)) { $parent_id = zen_get_categories_parent_id($current_category_id); zen_get_subcategoriesarray($subCategoriesArray, $relatedCategoriesId); } } $relatedCategoriesTotalNum = count($subCategoriesArray); ?> <div class="fl allborder line_180" id="relate_cate"> <h4 class="red line_30px in_1em"><?php echo BASE_COMMON_TEXT_RELATEDCATEGORIES; ?> </h4> <ul> <?php if ($relatedCategoriesTotalNum > 0) { for ($i = 0; $i < $display_num; $i++) { echo '<li><a href="' . zen_href_link(FILENAME_DEFAULT, 'cPath=' . $subCategoriesArray[$i]['categories_id']) . '" title="' . SEO_COMMON_KEYWORDS . $subCategoriesArray[$i]['categories_name'] . '">' . zen_clipped_string($subCategoriesArray[$i]['categories_name']) . '</a></li>'; } } unset($row, $display, $subCategoriesArray, $related_categories_query); ?> </ul>