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