so heres the deal. ive got a db table car_inventory. in there i have columns: vin, make, model, year, transmission, color and few more.
how do i make it so that when user lets say searches
make: ford
model: focus
year: 2002
he gets the results
or when he just puts ford in, gets all the fords.. and etc......