You may want to look over the system I am creating. It is for
neurobiology, but it uses categories. The URL
I am using both trees and colors.
Regarding your specific problem, you have to have an indexing table, which
will make the necessary relations between the different objects.
On Thu, 26 Sep 2002, Leif K-Brooks wrote:
> I'm trying to create a system to store virtual "objects". Each object
> will be in a category, and the categories may be in other categories.
> The categorie list might look something like:
> Healthy Food
> Vegeterian food
> Organic food
> Gross food
> I'm thinking of a datbase structure for the categorys something like:
> id (int, auto_inc, primary)
> name (text)
> insideof(int, id of other catrgory which this one is inside of)
> The problem is, I need to generate an indented list such as I showed
> before. I know how to do this with a lot of colors (selecting what each
> category contains, etc.), but is there a more effieient way? I use
> mysql. Thanks for any ideas.
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php