Modifying Categories Box

[Guest KevinMcD]

Hello,

I'm posting in the hope that someone can help me with a modification I am trying to make to CC4.

I have created a new box called 'Shop By Brand' which displays the child categories of the parent 'Brands' category. However, I want to now remove the Brands category from the main Category Box by altering the SQL query in categories.inc.php to exclude it. I've made some clumsy attempts at adding a WHERE clause for the cat_id<>34 but it generates an SQL error.

Can someone please tell me how I would modify the following CC query to exclude the category of ID=34'

$resultsForeign = $db->select("SELECT cat_master_id as cat_id, cat_name FROM ".$glob['dbprefix']."CubeCart_cats_lang WHERE cat_lang = ".$db->mySQLSafe(LANG_FOLDER));

Or perhaps there is an easier way to do it in the PHP that generates the menu?

Any help with this would be greatly appreciated.

K