Hello, Im almost completely done with a site but im getting stuck on one thing that is, at the moment, slightly over my head. Needing the help of someone who is fairly familure with OSCommerce

Ok, here is what im trying to do:

This is for a car parts site. The user wants be able to use a vehicle selector that will let him/her pick the Make/Model/Year from three drop down boxes. Once he selects the proper Make/Model/Year i need to pass the "Specific Model" and "Specific Year" into the php search page in OSCommerce.

The search results displayed would be exactly the same as if the user typed "1992 Thunderbird" into the search box...

I know it is possible to populate the drop down boxes directly from my mySQL database, but i really dont have a clue on how to go about that, so i would be more than ok with populating the drop-down box choices by hand.

Any and all help would be greatly appreciated

Thanks,
Matt

Update:

OK i have a much simpler request...

All i need is to figure out how to make a drop-down box set (three of em) jump to a URL...

the URL will be in the form "http://www.websitename.com/catalog/advanced_search_result.php?keywords=1999+thunderbi rd"

the "1999" will come from drop-down box #3 and "thunderbird" will come from drop-down box #2

anyone?

i'm not sure i get so here i go.

you have 3 select boxes and when you click submit you want that url to open?

ok, you create the form and put 3 selects in there. let's say "year" "model" "first_one".
now i don't know how to make it go directly to your url since that may require js,

but at the begining of the page you are submitting the data to you collect all 3 and use header() function to redirect to that page (header must be set before returning anything, whatsoever).


yet, i don't understand why you need to pass the values in the URL, when you can easily submit the page to advanced_search_results.php and pick them up internally using $_POST['year'] , $_POST['model'] and $_POST['first_one'] ...

I need the code to fit into be php...

is anyone want to make an offer... I am willing to pay for a solution that will..

Populate drop-down box#1 based on a mySQL table, then

populate drop-down box#2 with another SQL table, depending on the choice made in Box1

Populate the 3rd drop down box from SQL table based on the option selected in box2

then

pass the code into advanced_search.php in OSCommerce so that it will display the results as if the user did a search for the seclections they made in the boxes...


Thanks