tree like database structure

From: Abhi <aak_at_starline.ee>
Date: Wed, 8 Mar 2006 23:25:16 +0200
Message-ID: <440f4b90$1_2_at_news.estpak.ee>

Hi!

Can someone please direct me to a tutorial or give some hints? I am trying to develop a tree like database with MySQL.

I have main categories in one table. Now, each category has many subcategories and subcategories have their subcategories etc etc. All together seven levels.

How is such thing done most elegantly? I have some ideas with seven tables and too many category ID's. I am sure there are a lot of better ways to do this.

Sorry, for bad english, I hope I managed to explain the point.

Abhi Received on Wed Mar 08 2006 - 22:25:16 CET

This message: [ Message body ]
Next message: Mikito Harakiri: "Re: tree like database structure"
Previous message: JOG: "Re: OT - Dragoncountries (was: Declarative constraints in practical terms)"
Next in thread: Mikito Harakiri: "Re: tree like database structure"
Reply: Mikito Harakiri: "Re: tree like database structure"
Reply: -CELKO-: "Re: tree like database structure"
Reply: -CELKO-: "Re: tree like database structure"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message