6 Column Product Filter For Table In SQL Database - OSCommerce Shop

Avg Bid (USD)
Project Budget (USD)
$250 - $750

Project Description:
6 Level Filter For Table In SQL Database - OSCommerce

Hi I need a filter function for an OSC site V2.2 RC2

It needs to filter 6 columns in the "product description" table

Method is with drop down boxes.

Each box must be able to sort individually of each other.

Shop has around 350,000 products and growing

I will set up the columns and supply the name of the columns

The 6 drop down boxes to be arranged vertically

With a "Search" button at the bottom when the user has filtered to their requirements

When a filter is selected in any of the drop downs, only products with this selection are included in the remaining drop down menus if that makes sense?

Search results will bring up all products meeting filter criteria using the "product listing" layout.

If any product has one empty field in any of the columns it should be excluded from the filter process completely

Where a field is not filtered it should bring up all products with an entry in that column. ie default value is "Any"

Results should be limited to 100. If customer search finds more than 100 it should say "Too Many Results, Please Narrow Your Search Criteria"

No admin interface required

No involvement of categories required.

I will populate the columns myself

I am looking for code which I can copy and paste into the relevant "info box"

Results must be fast, close to instant. 2-3 seconds max

If you have an example of a site using something similar that would be great

These are the main points, please let me know what other information you require.

I am looking for a ball park figure to start with.

Skills required:
OSCommerce, PHP, Software Architecture, SQL
Hire Dave47
Project posted by:
Dave47 Egypt
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.

$ 435
in 5 days
$ 500
in 10 days
$ 300
in 7 days
$ 650
in 20 days
Hire techwelfare
$ 417
in 21 days
$ 700
in 27 days
$ 250
in 5 days
$ 600
in 20 days
Hire binhtq
$ 500
in 10 days
$ 280
in 5 days