Search by attributes option!!

[PhillipJFey]

I have had some success, in the last few days I successfully modified my Zen cart to filter by one attribute using a sidebox & modified database & index_filter page.

Currently trying to create a PHP or MySQL Function to filter by more then one attribute.

It’s messy and will take some time turn into a reliable modification to share online.

If anyone knows more about how to help let me know my challenge is as follows:

After grouping option_names using a new table, I simply created a new field in the category table linking to the option_group-id.

The side box simply shows drop down menu of the options for each category and post back into the index file.

With modification to index filters; using a left join on product attributes table you can successfully filter the contents of category using a single option.

I now need to create PHP function (if they can be exected inside an SQL Statement, which is unlikely) or MySQL Function as follows

SELECT p.products_id, pa.options_values_id FROM products AS p RIGHT JOIN products_attributes AS pa ON p.products_id = pa.products_id WHERE (((p.products_id)=24) AND ((pa.options_values_id) In (2,7,9)));

By returning the & comparing the number of attribute matches you know if it meets your search criteria.

By adding this into the normal $listing_sql statement it should work.

If anyone can help, let me know.

[PhillipJFey]

Success works for up to nine attributes (tested up to 3).

visit www.ogzstore.co.uk; the Gadgets -> Science to see in action.

If there enough demand will make it into a mod to download.

[abran1984]

Phillip; I don't see your a Gadgets > Science category on your web site? Did you get this working?