Avatar of joiko

asked on 

How do I find path when leaf node is unknown?

I've used nested sets methodology proposed by Celko to create a tree for calculating MLM commissions.  I need to find if any node meets certain characteristics (i.e. "rank") between the parent node and the terminating leaf node, when I do not know the left or right values of the leaf node or how many nodes are between the parent and the leaf.

Key fields are:

Any suggestions?  I am wrting in ASP using mySQL as database.

I could alternatively work from down up (in which I would know the leaf node) but need to find the first instance above the leaf node that meets the rank qualifications.

Thanks in advance for your help.
SoftwareDatabasesMySQL Server

Avatar of undefined
Last Comment

8/22/2022 - Mon