How to get Sub-Category ID ?

[allright]

Hi all,

 

I have $current_category_id now, how can I extract its sub categories' ID ?

 

Your kind hint is greatly appreciated, thank you.

 

Best regards,

allright

[roya.k]

<?php
$sub_categories_query = tep_db_query("select categories_id from " . TABLE_CATEGORIES . "  where parent_id = '" . (int)$current_category_id."'");
while ($sub_categories = tep_db_fetch_array($sub_categories_query)) {
echo $sub_categories['categories_id']; /// or what you want
}
?>

[roya.k]

another solution, more elegant:

 

<?php
$arr= tep_get_categories('', (int)$current_category_id);
for ($i=0; $i<sizeof($arr); $i++) {
echo $arr[$i]['id']; /// or what you want
}
?>

[burt]

Should think before I post ;)

 

As above - my way would only work the other way, using previous. Ignore. Use as above.

[ydhcxh]

Very good