I need a a very simnple autoparts catalog and search script. There are 4 tables: vehicles, products, product-images, pvjoin. *vehicles is very simple: vehicleid, year, make, model, application. *Products: productid, category, subcategory, sku, ean, azin, name, description, manufacturer.0* images: imageid, productid, image.
what i need: a search form, search by model>make>year>application>category>subcategory> and get a list of parts, once we are in a part, show all vehicles that this part is associated with.
this little app will need a way to easily relate parts with vehicles thru a join table (pvjoin)