Wow, that's helpful :( Here's a prior post that should set you in the right direction: http://marc.theaimsgroup.com/?l=php-general&m=104815166325490&w=2 olinux --- Blain <Blain@gmx.ch> wrote: > If you can sort it and give all entrys a > indent number its easy to read the tree out. > > -----Ursprungliche Nachricht----- > Von: Leif K-Brooks > [mailto:eurleif@buyer-brokerage.com] > Gesendet: Donnerstag, 27. Marz 2003 03:19 > An: php-db@lists.php.net > Betreff: Generating view of tree? > > > I have a table with a tree. Thing is, I need to > generate a view of it like: > Category > Sub-category > Sub-sub-category > Another sub-category > Another category > Sub-category > > Any way to do this, without using a huge number of > queries? Using MySQL. > > > -- > 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 > __________________________________________________ Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! http://platinum.yahoo.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php