Jump to content

database design issue


pat09

Recommended Posts

I am a newbie in php/mySQL. I am designing a website that will display a product catalog.

 

There are about 6 sections of products, each section has about 10 groups, and each group has about 10 to 20 products.

Each group has a certain number of properties for every product in that group. (e.g weight, size, color etc.)

The number/name of properties varies with each group. These properties are to be displayed in a particular order.

 

Each section/group/product will be displayed in a particular order.

 

The tables I have outlined for this database are:

 

parts table

id

part_no

description

 

properties table

id

name

 

part_properties table

id

part_id

property_id

property_value

 

groups table

id

group_name

 

groups_parts table

group_id

part_id

 

My questions are:

how do I display the properties in the order that is required?

how do I dipslay the products/groups in the order required?

 

What I thought of doing is adding appropriate fields these tables that will hold the position value.

Is this the best way to do this? Is there a way to do this in php?

Any kind of guidance would be appreciated.

 

 

 

 

Link to comment
Share on other sites

Yeah. It's common when ordering matters to add a 'listIndex' or something similar column.

 

If you remove one of them and forget to update the indices, though, it's a pain in the ass.

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

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.