Re: Making tree menu

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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 <lists@dharik.com> 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


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux