[Phpgedview-talk] Places Hierarchy
Brought to you by:
canajun2eh,
yalnifj
From: Nathan S. H. <nat...@uk...> - 2007-09-28 09:57:54
|
I'm pretty new to phpgedview, but I have some experience with PHP and MySQL. I may have some input to the way places are stored, but first I have a few questions: 1) What's the difference between the pgv_places and pgv_placelocation tables? 2) Does the hierarchical structure have to be stored using a parent_id to link the child to it's parent? a) Is anyone aware of the nested sets model for storing hierarchies? I believe there are several features that would make this implementation of a hierarchy beneficial to PGV. I have some PHP code that I use for doing hierarchy manipulations, e.g. adding/deleting nodes etc Anyway, I'll await responses from those more in the known about PGV. Cheers Nathan |