http://searchdatabase.techtarget.com/tip/1,289483,sid13_gci801943,00.html Similar situation in the tutorial, it's an org chart. =C= * Cal Evans * http://www.christianperformer.com * Stay plugged into your audience * The measure of a programmer is not the number of lines of code he writes but the number of lines he does not have to write. ----- Original Message ----- From: "Charles Kline" <ckline@rightcode.net> To: <php-db@lists.php.net> Sent: Sunday, May 04, 2003 10:30 AM Subject: data structure help needed > hi all, > > i am developing a site where users will be related in a parent-child > type relationship. > > my users table is like this: > > id | user | parent > --------------------------------- > 1 | joe | null > 2 | bill | null > 3 | fred | 1 > 4 | john | 3 > 5 | frank | 3 > etc. > > Any user may have many children - what I want to do is traverse the > tree in such a way that I can go up the family tree from any spot and > see who is related. > > Anyone know of a good tutorial or a point in the right direction? I > think this will require some recursive statement, which I have not done > in PHP or MySQL before. > > Thanks > Charles > > > -- > 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
