> Thank You. Tell me if I misunderstood or if I did not express me
> clearly.

Sounds like you got it! :)

You may also want to read up on nested sets for your database structure.
They work the parent_id and child_id differently and it may make queries
easier for your situation. For instance, with nested sets, you can easily
find out everyone that decended from a single person with one query. Doing
that with the parent_child solution can take many queries. However,
inserting is more demanding with nested sets, but if you're not going to do
a whole lot of inserting after the database is populated, then it may be for
you.

Here's one explanation... search for others:
http://threebit.net/tutorials/nestedset/tutorial1.html#t

---John Holmes...


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to