Select the rows like a tree view

[phpmady]

Hi,

 

I have the project where i want to get the structure like tree.

 

My table structure:

 

Section_Id Section_Parent  Section_Name

1                0                        America

2                0                        China

3                1                      New york

4                1                      Washington

5                2                      Buffalo

 

How to retrieve the records..

 

I need a structure like this in a select button:

 

America

  New york

    Buffalo

 

 

Thanks,

 

 

 

 

 

 

 

 

[premiso]

I would take a look at the following:

 

http://www.ferdychristant.com/blog/archive/DOMM-7QJPM7

 

I used to have a more elegant resource but I cannot find the link anymore. If I find that I will post it. But your google terms, if you decide to do more research should be:  MySQL Hierarchical

[phpmady]

Thank you, more useful for me,

 

nice to know the correct keyword mysql hierarchy

 

 

Thanks