[subhashparayil]

Hi friend,

I am in developing a MLM website using ASP for implementing this program, I need find the total number of sub nodes( left and right ) in a particular node. I attached the database structure and pictorial representation of nodes in database. Please check it.

I need the sql query that implementing the program.

1. Find the total number of subnodes of a particular node.
2. Find the total number of left handside nodes of a particular node.
2. Find the total number of right handside nodes of a particular node.

Please give me the idea.

warm regards
Subhash

[Christian]

Thread moved to appropriate forum...

just use select count(*) from table where field = 'some string' that should give you the numbers, unless i am misunderstanding what you want