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>
