Filters and database


the purpose of my site is to display cars which I am selling. just like any other sites I want to give my viewers the ability to narrow their search down to what thy want. So I want to create filters on my page, the customer can select which brand, price, color, mileage, age and transmission of the car they want and the site will display only the relevant car or cars.
in my database collection, where all the information of the cars in stock are kept, has this information for every single car. I just need to figure out how to create this filter which can connect to database and pull out a relevant car, saving the customers time by going through every single car.

it is worth mentioning that i have two pages, one from current stock and one from sold cars. I only have one database collection and i display the relevant cars in the relevant section by using a filter in database management.

Thank you for your responses

Hi,
See here a post about similar behaviour (is this case, filtering job list according to multiple drop downs).

Liran.

Hello,

I didn’t find that post helpful. Can someone explain to me how to manage more than one drop down menu for filtering a table?

Thank you.