Id Like to keep this on the forum as others could gain from this.
I dont know why you want the search result to turn up subcategories?
This make things complex and time consuming for the user.
If you look at my advanced search I could easily show you how to turn my My Feild Vehicle Application into 3 Drop Down Lists.
www.landspeedracing.com
You Can Only use you method of using Param00,01,02
IF Each Product Only Has ONE application.
IF You are LIKE ME, one product works for 5 different applications i.e. 90-02 Honda Civic EX/97-02 Acura Integra GS/88-91 Honda CRX.
Now This Creates a difficult situation for me. I have no problems Searching for Model or Manufacture but when it comes to Searching for a persons Particular Year it makes things a little bit different. Either you need to list out each year or have an algorythm that checks to see if the year is within the Product Application Range. Either Way you still screwed because how do you Tie together the Year Ranges in Param00 with The Manufacture in Param01 with the Model in Param02 if each feild contains info for more than one application.
I have thought of some methods using custom delimiters and indexing within the Feild but they are Awfully Messsy.
The Other thought is to create a new Table Called Applications.
Basicly each row will have a Product_id feild a Year Feild with either a year range or each applicable year seperated be a space, Model Feild, a Manufacture Feild, and Notes Feild(for weird exlusions... i.e. manual tranny only...)
My Question IS, Do You Want a Better Advanced Search Feature or do you want to Filter out the products that are Displayed so somone just sees the Products that are applicable to the Car Year Manu Model the user has chosen.
I must say I have put this off and put it off as much as my customers would like this feature as this is the NORM for searching for Car Parts, I have so many products I would need to modify the Import Products to be able to import this info.
Now if you just want an advanced search that Lets user select the Manu. and Model As Mine Does I can simply help you out.
If you want more than this then Im interested in helping out answer any question give any guidence but it would be considerable work to do this myself so I would have to have some insentive if you are not up to par with doing you own MOD.
Scott[/img]