231140 osCommerce Car model Search

In Progress Posted Jun 20, 2008 Paid on delivery
In Progress Paid on delivery

I need three drop down boxes so a customer can search by vehicle make, model, and year. Using a modified [url removed, login to view] and/or [url removed, login to view] file is OK. I need a php file that I can place into a box on one of the columns.

I have a database table that looks similar this:

Product ID, Car Make, Car Model, Car Year Start, Car Year End

62960, Acura, CL, 1980, 2003

62964, Chevrolet, Corvette, 1968, 1982

Unless there is a is a better way to do it, here is what I need the box to do:

When a customer chooses the manufacturer "Acura" I want all vehicle makes that Acura offers to be available in the Model box. When the customer then chooses "CL" I want the years to show up.

An alternative is to have the years show up first, then the car models that have that year assigned to them, then the car model.

MySQL Odd Jobs PHP Script Install

Project ID: #1977383

About the project

Remote project Active Jul 11, 2012