Dynamic Filter [Support Thread]

[Design75]

Same here.

I tried escaping the " and or '. No luck.

The only thing that does not produce an error, is the following format:


But try to tell a shop owner to look at the following and do your additions, deletions, edits and audits and etc.


How is that for head spin?

I am trying to figure out a way also.

Thanks.




ps. Spaces between & and # are left out, so it displays here.

Here's a quick solution,

find in includes/modules/YUOR_TEMPLATE/dynamic_filter.php

          $having .= ' FIND_IN_SET("' . $key . $value . '", GROUP_CONCAT(CONCAT(REPLACE(po.products_options_name, " ", ""), pov.products_options_values_name)))'; 

replace with:

          $value = preg_replace('/"/','\\"',$value);
          $value = preg_replace('/&acute/','\\&acute',$value);
          $having .= ' FIND_IN_SET("' . $key . $value . '", GROUP_CONCAT(CONCAT(REPLACE(po.products_options_name, " ", ""), pov.products_options_values_name)))'; 

more values can be added if needed