Jump to content


Photo

online store help.


  • Please log in to reply
3 replies to this topic

#1 dragonusthei

dragonusthei
  • Members
  • PipPipPip
  • Advanced Member
  • 46 posts

Posted 22 September 2006 - 03:25 PM

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?


Table 1 - products

id
name
f_price
stock
trade_price
image_html
desc_html

se_title
se_keywords
se_desc



Table 2 - cat_in

id
cat_id
p_id



Table 3 - p_options

id
p_id
option_name
option_price
option_weight


#2 dragonusthei

dragonusthei
  • Members
  • PipPipPip
  • Advanced Member
  • 46 posts

Posted 22 September 2006 - 04:50 PM

Any one?

#3 dragonusthei

dragonusthei
  • Members
  • PipPipPip
  • Advanced Member
  • 46 posts

Posted 22 September 2006 - 06:30 PM

come on guys im desc for help here

#4 tleisher

tleisher
  • Members
  • PipPipPip
  • Advanced Member
  • 88 posts

Posted 22 September 2006 - 06:48 PM

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.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users