dynamic menu changes

Is there a simple way of temporarily or permanently removing a product category or subcategory from a dynamic menu. Is adding a productlive column to these two tables the way to do it?

adding an active column to the table, setting it to a value of 1 or 0 then updating the recordsets that build the menu to only return records where the active column equals 1 will remove the category temporarily.

if you want to remove it permanently, delete the record from the table.

I've created the extra active columns in the productcategory and productsubcategory tables and realised that the dynamic menu wizzard seems to only allow one filter selection. I already have a GroupID filter in productcategory and a nested filter in productsubcategory as shown in the screenshot.

The only place I can see to add the extra WHERE for the active columns is in the recordsets for menu.php as shown in the screenshot.

Is this the only way to achieve this, if so what is the correct SQL to add after the existing WHERE?

yes, that is the only way to add the extra filter.


the current where clause is:

WHERE Group=1

change that to:
WHERE Group=1 AND active=1

Thanks Jason, it all works fine now.

H Jason

I can temporarily switch off a category and subcategory individually as your instructions.
Is it possible when switching off a category to also automatically switch off the subcategory associated with it?

To clarify my earlier post, I have been successfull in switching off a category and its subcategory in the navbar navigation. My question was related to a dynamic search list (not the navbar) which I have added to the site.

I'm not sure i follow what you mean, please provide more detail.

Ok, I've attached a screenshot which shows two dropdowns, one for category and the other for subcategory (still building site so not pretty yet).

If I switch off a category in the left dropdown the corresponding subcategory still shows in the right dropdown.

I would like the subcategory to disappear automatically when a category is switched off.

Hope this is clear.

My previous post still needs an answer but I've discovered another problem with the edited menu.php where I added the extra filter for the category and subcategory live columns.

Everything worked great until I made a subsequent change to the menu which caused the menu.php to be updated.

The new menu.php loses the previous manual edit for the live columns and I have to re-enter the original 8 extra filter statements.

Is there a way to keep these statements for all subsequent menu.php updates?