<div>
Wouldn't this find such nodes:<br />
<br />

<pre><code class="code-1 nolinks" id="code-263613"><span>select * from tree </span>
<span>where </span>
<span>  lft between @parent_lft and @parent_rgt and</span>
<span>  rgt between @parent_lft and @parent_rgt and</span>
<span>  rank &gt; @required_rank</span>
</code></pre>
</div>


<div>
Yep, that looks good. It is about the only way to achieve it, otherwise you end up with every branch, not just the path that contains your node.<br />
<br />
Though doubt if we could have got to exactly the same solution, you seem to have a few extra bits n pieces n names...<br />
<br />

</div>


<div>
For what it is worth, my recommendation would be Delete with Refund. Unless the asker would prefer to accept their own posting as the answer and award points to cxr as the inspiration to their solution.
</div>


<div>
Ok -- this is strange -- apparently, I don't know what I'm supposed to do here. &nbsp;I read the link -- I cancelled my account (free trial) first because I didn't get useful responses or much activity. &nbsp;Saw that there were new postings so I figured maybe I'm getting activity and maybe some ideas... only to find that I somehow did something wrong -- I don't see a choice to not to accept answer or to close out... what am I missing here? &nbsp;could someone explain or point me in the right direction. 
</div>


<div>
No, you have not done anything wrong.<br />
<br />
This is part of a cleanup process to make sure EE is kept in a clean state.<br />
<br />
You do not have to do anything really, the clean up process does catch and clean abandoned threads.<br />
<br />
What is &quot;good&quot; form and the preferred interaction is for you to close the question as you see fit rather than add to the burdons of abandoned questions.<br />
<br />
Given your comment, would suggest that you 'delete' the question.
</div>


<div>
<div class="content wysiwyg-content">
I've used nested sets methodology proposed by Celko to create a tree for calculating MLM commissions. &nbsp;I need to find if any node meets certain characteristics (i.e. &quot;rank&quot;) 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.<br />
<br />
Key fields are:<br />
lft<br />
rgt<br />
idNumber<br />
rank<br />
<br />
Any suggestions? &nbsp;I am wrting in ASP using mySQL as database.<br />
<br />
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.<br />
<br />
Thanks in advance for your help.
</div>
</div>


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:
lft
rgt
idNumber
rank

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.

How do I find path when leaf node is unknown?

Software is any set of instructions that directs a computer to perform specific tasks or operations. Computer software consists of programs, libraries and related non-executable data (such as documentation). Computer software is non-tangible, contrasted with computer hardware, which is the physical component of computers. Software written in a machine language is known as "machine code". However, in practice, software is usually written in high-level programming languages than machine language. High-level languages are translated into machine language using a compiler or interpreter or a combination of the two.

Software

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.