There are two ways that I know of the adjacency model
and nested sets.
adjacency model uses a table structure like
category_id | parent_id | category_name
so if i want to see all categories belonging to
category 12
- SELECT * FROM cat_table WHERE parent_id=12;
there are a few articles out there on this. not sure
where at the moment, but you know what its called now.
here are some articles about the nested set model. A
little more difficult but with great benefits
- http://www.dbmsmag.com/9603d06.html
-
http://searchdatabase.techtarget.com/tip/1,289483,sid13_gci537290,00.html
-
http://searchdatabase.techtarget.com/tip/1,289483,sid13_gci801943,00.html
olinux
--- Daniel Harik [EMAIL PROTECTED] wrote:
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
__
Do you Yahoo!?
Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!
http://platinum.yahoo.com
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php