HI,
I have been having a bit of trouble trying to get the right sql statement to bring up correct options for specific products.
I am working on a fashion site. When a product id is selected I want the page to filter to display the correct options from the recordset.
Can someone please advised me.
So far I have products and options in their own tables:
Products (table)
--------------------------------------------------------------------------------------------
ProductID int(11) auto_increment primary key,
ProductName varchar(50)
etc
TShirt (table) option
---------------------------------------------------------------------------------------------
ts_id int(11) auto_increment primary key,
tsSIZE varchar(20) [this is for actual size e.g. small, medium, large, x large.]
ProductID int(11) [this is foreign key for product ids]
DressSize (table) option
----------------------------------------------------------------------------------------------
ds_id int(11) auto_increment primary key,
drSIZE varchar(20) [this is for actual size e.g. size 4, size 6, size 8, size 10.]
ProductID int(11) [this is foreign key for product ids]