Sub-categories box

[Guest neil_r]

Hello all,

I'd like to create a new version of categories.inc.php to give a list of links to the sub-categories of a specific category.

I can create the new box and alter the global templates to show it; my problem is that I don't know how to alter the new version of categories.inc.php (let's call it sub_categories.inc.php) so that it only pulls certain (or any!) subcategories from the database. It appears that this was easy in v3 beacause you only needed to alter the cat_father_id in the line

$results = $db->select("SELECT cat_name, cat_id FROM ".$glob['dbprefix']."CubeCart_category WHERE cat_father_id = 0");

CC 4 doesn't use this method. So my question is, how do I alter my new file sub_categories.inc.php to achieve this?

Regards,

Neil