Jump to content


This topic is now archived and is closed to further replies.


Filter Search Results

Recommended Posts

I am finishing up an e-commerce site for my company. There is an advanced search feature in which I have included additional fields specific to the type of product. Basically, you can define (from select menus) the Manufacturer, the Category, the Color, the Style, Price range, and Width range and it will spit out the products that are pertinent to these results. Standard and working.
My goal is to have these menus included on the search results page. The options in the menus on results page should then be limited to the available options in the results returned. So, if you pick a manufacturer (submits query) the remaining menus will limit their options to product's attributes that are available from that Manufacturer. If there are 10 total colors in the system, and Manufacturer A only has 5 of those colors then only those 5 colors will be available.
I tried $_GETing the variables and doing a new query for each menu. It wasn't clean and I would like to avoid more queries since there will eventually be 30,000+ products. I am thinking about trying to run a unique() on each needed field of the returned results. Maybe there is a better approach, any ideas?

Thank you for your input

If I can get this running right and cleaned up I am going to submit it as an OsCommerce Contribute.

Share this post

Link to post
Share on other sites
It really does depend on how you've got your database setup as to how easy it is.  As with most things, it's possible, but I don't think it's going to be easy.  Have you modified the database at all, or is it the default OsCommerce one?

Perhaps it would be better posted in the third-party forum.  Don't forget to include the version ;)


Share this post

Link to post
Share on other sites
It has been moved: [url=http://www.phpfreaks.com/forums/index.php/topic,109727.msg442532.html#msg442532]http://www.phpfreaks.com/forums/index.php/topic,109727.msg442532.html#msg442532[/url]

Share this post

Link to post
Share on other sites
This topic is now closed to further replies.


Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.