I don't think it's possible purely with SQL using MySQL. I tried researching
it just a few days ago, and found Oracle supports a clause CONNECT BY ...
PRIOR (more info at http://www.arsdigita.com/books/sql/trees.html) which
does this for you, but it's still in the MySQL todo list
(http://www.mysql.com/doc/T/O/TODO_future.html).
If you are using PHP, I can send you to some code which will accomplish the
same thing.
> I'm having a lot of difficulty trying to figure this out. I have a table
> with a list of projects that I would like to arrange and view as a tree.
> This is my table:
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
