product filter module addon

[macnerd]

curious - has this been resolved? are you able to have only values used by the category show?

am running Dynamic Filter on my site, but it is far less than optimal....

At the moment this mod displays all option values in the database. I am trying to have the option values display only if they are in use by the category selected.

Now, I can filter option values based on simple criteria such as sort order or id, but it's the filtering of values that are 'in use' that's giving me trouble.

This code seems to denote which option values are displayed:

$option_names_values = $db->Execute("select pov.products_options_values_id, pov.products_options_values_name from ". TABLE_PRODUCTS_OPTIONS_VALUES_TO_PRODUCTS_OPTIONS." povp,".TABLE_PRODUCTS_OPTIONS_VALUES." pov where povp.products_options_values_id = pov.products_options_values_id AND povp.products_options_id = ".$option_names->fields['products_options_id']);

If anyone has a suggestion as to how I can display option values that apply only to products in the current category, it would be a big help.