bindVars($categories_query, ':parentID', $current_category_id, 'integer');
$categories_query = $db->bindVars($categories_query, ':languagesID', $_SESSION['languages_id'], 'integer');
$categories_row = $db->Execute($categories_query);
$number_of_categories = $categories_row->RecordCount();
$new_products_category_id = $current_category_id;
$rows = 0;
while (!$categories_row->EOF) {
$rows++;
$cPath_new = zen_get_path($categories_row->fields['categories_id']);
// strio out 0_ from top level
$cPath_new = str_replace('=0_', '=', $cPath_new);
$width = (int)(100 / MAX_DISPLAY_CATEGORIES_PER_ROW) . '%';
$newrow = false;
if ((($rows / MAX_DISPLAY_CATEGORIES_PER_ROW) == floor($rows / MAX_DISPLAY_CATEGORIES_PER_ROW)) && ($rows != $number_of_categories))
{
$newrow = true;
}
if (!$categories_row->fields['categories_image']) !$categories_row->fields['categories_image'] = 'pixel_trans.gif';
// start amazon style sub-cats in category lists
// start config variables
// display limit - adjust $limit to the number of subcats to display under parent category (4 or 5 seems right)
$limit = '4';
// subcat prefix - enter your preferred subcat prefix (bullets are default)
$subs_indent = '• ';
// no sub-cats - display this if there are no sub-cats within a category. Leave both values blank (see below) if you want to display only the category name
$no_subs_indent = '» ';
$no_subs_prefix = 'View Products';
//$no_subs_indent = '';
//$no_subs_prefix = '';
// sub-cats exceed display limit - indent and text prefix to display if sub-cats exceed display limit (eg - More {CATEGORY NAME})
$limit_exceeded_indent = '»» ';
$limit_exceeded_prefix = 'More ';
// end config variables
$parent_id = $categories_row->fields[categories_id];
$sql = "select c.categories_id, cd.categories_name
from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd
where c.parent_id = '" . (int)$parent_id . "'
and c.categories_id = cd.categories_id
and cd.language_id = '" . (int)$_SESSION['languages_id'] . "'
and c.categories_status= '1'
order by sort_order, cd.categories_name";
$subcats = $db->Execute($sql);
$subs_string = "";
//if ($subcats->EOF) $subs_string .= '
' . $no_subs_indent . '' . $no_subs_prefix . '';
if ($subcats->EOF) $subs_string .= '';
while (!$subcats->EOF) {
if ($limit == $subcats->cursor) {
//$subs_string .= '
' . $limit_exceeded_indent . '' . $limit_exceeded_prefix . $categories_row->fields[categories_name] . '';
$subs_string .= '';
break;
}
$cPath_subs = $cPath_new . '_' . $subcats->fields[categories_id];
$subs_string .= '';
$subcats->MoveNext();
}
// end add sub-cat bullets to category rows
?>
fields['categories_name']; ?>
MoveNext();}?>