im looking for some sample code to draw,build or generate an organiztion chart, cause im not very good at algorithm
and all i found is just a binary tree so it's not much useful for an organization chart.
thanks in advance,

Perhaps search here:

HotScripts.com
http://www.hotscripts.com

Planet Source Code
http://www.planet-source-code.com

The ASP Resource Index
http://www.aspin.com

i've searched all of those web site but never found anything close to what im looking for. i found one component(not free) with a powerful tools to create an organization chart on the web(just only one that i've found) but i just want a sample code to learn , not a complete package.
i wonder that there is no a sample code about organization chart?

my database is just look like this

id name parent_id
1 A null <--------root
2 B 1
3 C 1
4 D 1
5 E 2
6 F 2
7 G 3
8 H 4
9 I 4
10 J 4
11 K 9

and the result should look like this (with link line)

A
|
|------------------|-----------------|
B C D
|----------| | |----|---------|
E F G H I J
|
K

that's it =)
and by the way,this post will cut all space ,so my result chart may look not very right.
thanks,

pehaps it would help if you provided a link to a page where you could control how the chart should look

yes, here is an example.

http://www22.brinkster.com/bebebe/example.html

You can do it with recursive functions, with tree graphs.

If you were using Oracle, you would be able to use CONNECT BY statement to do this.

You can read Mr. Celko 's articles @:

http://www.dbmsmag.com/9603d06.html
http://www.dbmsmag.com/9604d06.html
http://www.dbmsmag.com/9605d06.html
http://www.dbmsmag.com/9606d06.html