so i want to create a database which will have information about item. so first user will have to choice main_catgory, than sub_catgory, than item info. so for ex:

------------
main_catgory
------------
apparel
home decor
beauty

-----------
sub_catgory
------------
male
female
furniture
accessories
bath and body
hair care

-----------------
item
-----------------
image_full_name
image_short_name
our_price
description
features

iam thinking of making 3 different tables.

    table 1
    table name: item:
    row 1 name: id
    row 2 name: image_full_name
    row 3 name: image_short_name
    row 4 name: price
    row 5 name: description
    row 6 name: features


    table 2
    table name: main_catgory:
    row 1 name: id
    row 2 name: catgory


    table 3
     table name: sub_catgory:
    row 1 name: id
    row 2 name: catgory




let me know if i should add more rows

item should link to sub, and sub should link to main.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.21 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.