Re: Automotive Product Database (Structer & PHP)

[Andrew Mallicoat]

Lets elaborate on this a little...
heres my product table:
+------------------+-------------------+--------------------------+----------------------------------+-------------------------+
| PRODUCT_ID | PRODUCT_SKU | PRODUCT_NAME | PRODUCT_DESCRIPTION | PRODUCT_IMAGE |
+------------------+--------------------+-------------------------+----------------------------------+-------------------------+
and vehicles:
+----------------+-------+--------+------------+
| VEHICLE_ID | YEAR | MAKE | MODEL |
+----------------+-------+--------+------------+

now i should create a table that lists the applications of a particular product like this:

VEH_PRO
PRODUCT_ID ---------ex. 90034
VEHICLE_ID -----------ex.45823

now this doesnt seem to work for multiple applications

could i put multiple vehicle_id's in and use a search function to narrow it to a particular vehicle such as:

VEH_PRO
PRODUCT_ID ---------ex. 90034
VEHICLE_ID -----------ex.45823, 78345, 84859, 28485, 10989