need help outputing mysql data in hierarchical format

[marcin_koss]

Here's the mysql table

 

ID

1

2

3

4

5

6

7

8

9

NAME

web development

computer graphics

photography

php

javascript

360 pano

HDR images

jquery

ajax

PARENT

0

0

0

1

1

3

3

5

5

 

I need to output this data in hierarchical format like this:

 

web development

- php

- javascript

    - jquery

    - ajax

computer graphics

photography

- 360 pano

- HDR image

 

I tried to figure this out but I'm out of ideas...anyone?

[PravinS]

You have to use recursive function to get data in required format. I have create on multilevel menu with same recursive functionality, you can refer it.

 

Download URL: http://www.phpclasses.org/browse/package/5927.html

 

refer functions.php file, where it have getMenu() and getChild() functions.