online store help.

[dragonusthei]

Hello

Im currently programming an online store

i just need some advice

some of the items in store will have size options some wont.

some of the items will go in more than one catagory

here my current database plan, could some one tell me if this looks good for what im trying to do or is there a better way?


[b]Table 1 - products[/b]

id
name
f_price
stock
trade_price
image_html
desc_html

se_title
se_keywords
se_desc



[b]Table 2 - cat_in[/b]

id
cat_id
p_id



[b]Table 3 - p_options[/b]

id
p_id
option_name
option_price
option_weight

[dragonusthei]

Any one?

[dragonusthei]

come on guys im desc for help here

[tleisher]

Looks fine to me, in terms of checking to see if one has a size and one doesn't, just leave the size column blank if it has none, then do an if statement seeing if its blank or if it has something in it.