No. With the method you're using (storing the parent id with each record)
you have to use a recursive series of queries to show the subtree levels.
Take a look at this article--especially the second and third pages about the
modified preorder tree traversal and nested sets. There are many other
articles on this, but I found this one especially helpful starting out. It
will let you do what you want, but this method has its drawbacks too.
http://www.sitepoint.com/article/1105
_________________________________________________________________
Let the new MSN Premium Internet Software make the most of your high-speed
experience. http://join.msn.com/?pgmarket=en-us&page=byoa/prem&ST=1
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]