MySQL Forums
Forum List  »  PHP

many to many relational database
Posted by: Simion Ursache
Date: April 26, 2005 02:09PM

Hello to all staff of MySQL Freaks and all php'ers !

I am quite new in PHP and MySQL programming but i have some experience though since i have developed 3 major sites.

Now i am woking on a new website and i have encoutered some kind of a problem.

I have to a site with a lot of products that are distribuited to different categories. These categories must be fully customizable with 9 major categorie and each major category with other 9 subcategory. Here is an example :



categ 1 - subcateg 1.1
- subcateg 1.2
- subcateg 1.3
....................
- subcateg 1.9

categ 2 - subcateg 2.1 - subcateg 2.1.1
- subcateg 2.1.2
.......................
- subcateg 2.1.9 - subcateg 2.1.9.1
- subcateg 2.1.9.2
..........................
- subcateg 2.1.9.9


- subcateg 2.2
- subcateg 2.3
....................
- subcateg 2.9
.....................................................................................
categ 9 - and so on




some kind of a 9x9 matrix .

what i was thinking was in creating a 9 categ database with an id and name field..and an relational database that contains the id's of all the categories , but i'm sue that there could be a more eficient way to do this.

So if you have an ideea please reply.

Thanks in advance !

Options: ReplyQuote


Subject
Written By
Posted
many to many relational database
April 26, 2005 02:09PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.