Code:
$categories_data = func_query("select $sql_tbl[categories].*, SUBSTRING_INDEX($sql_tbl[categories].category, '\/', -1) as category_name, SUBSTRING_INDEX($sql_tbl[categories].category, '\/', 1) as root_category_name, SUBSTRING_INDEX(SUBSTRING_INDEX($sql_tbl[categories].category, '\/', -2),'\/',1) as sub_category_name from $sql_tbl[categories] ".($current_area=="C"?"where $sql_tbl[categories].avail='Y' $membership_condition ":"")." group by $sql_tbl[categories].categoryid order by ".($current_area=="C" ? "order_by" : "category"));
This will get the sub_category_name as well.
template code for the 1st tier from root:
Code:
{if $categories_data[subcat_num].root_category_name == $categories_data[cat_num].category && $categories_data[subcat_num].category_name != $categories_data[cat_num].category_name && $categories_data[subcat_num].sub_category_name == $categories_data[subcat_num].root_category_name}