[thelist] [DB Design] Recursive Directory Structure
Ken Kogler
ken.kogler at curf.edu
Sat Feb 1 19:21:00 CST 2003
I don't even know where to start googling on this one... Nothing useful
has been turned up yet.
I want to emulate a directory structure in a database. I don't want to
have to traverse the filesystem on the server as I'm already making
calls to the database (prefrences, config, etc). The structure is
something like this:
Beef
hamburger
steak
sirloin
strip
ribeye
Chicken
sandwiches
rotisserie
grilled
Pork
bacon
ribs
chops
If it was a 2-level thing, I could do it with no problem. But I do have
a problem -- this needs to be n-levels deep. I have no clue how many
levels this could eventually end up as.
This is for an online photo gallery -- I'm trying to allow for the
possibility of nested albums.
Am I explaining this clearly?
Thanks everyone!
--Ken
More information about the thelist
mailing list