MySQL Forums
Forum List  »  Newbie

Storing a directory type structure
Posted by: Simon Ingham
Date: May 19, 2005 03:16PM

I have a requirment to store a directory/group type of structure in a database

I have an existing table of items for which i need to be able to store group information in the manner similar to the following

group 1
subgroup 1
subsubgroup1
item1
item2
item3
subsubgroup2
item4
item5
item6
subgroup 2
item 7
item 8
item 9
group 2
item 10
item 11
item 12

The problem i am having is that an item can be in any level of subgrouping and the total level of subroups is undefined

I am open to any suggestions

Regards Simon

Options: ReplyQuote


Subject
Written By
Posted
Storing a directory type structure
May 19, 2005 03:16PM


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.