[PHP-DB] Categorized list?

2002-09-26 Thread Leif K-Brooks

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:
Food
Candy
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




Re: [PHP-DB] Categorized list?

2002-09-26 Thread Mihail Bota

Leif,

You may want to look over the system I am creating. It is for
neurobiology, but it uses categories. The URL
is http://brancusi.usc.edu/bkms
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.

Mihai

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:
 Food
 Candy
 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