Jump to content

Archived

This topic is now archived and is closed to further replies.

dragonusthei

online store help.

Recommended Posts

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

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.