Hello guys

I make following query:

mysql> SELECT b.type, a.link AS parent_link, b.link AS child_link FROM 
bookmarks AS a, bookmarks AS b WHERE a.id = b.parentid order by 
parent_link;

and here is result

+--------+-------------+------------------------+
| type   | parent_link | child_link             |
+--------+-------------+------------------------+
| link   | MAIN FOLDER | http://www.ee/         |
| folder | MAIN FOLDER | SUBFOLDER              |
| link   | MAIN FOLDER | http://www.google.com/ |
| link   | SUBFOLDER   | http://www.amazon.com/ |
+--------+-------------+------------------------+

I just can't figure out how can i produce tree style output with php

MAIN FOLDER ->
              -> http://www.google.com/
              -> http://www.ee/ 
              -> SUBFOLDER
                          -> http://www.amazon.com/


Any help would be greatly apreciated. 
Have a nice day.

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to