Generating view of tree?

[Leif K-Brooks <eurleif@buyer-brokerage.com>]

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