[Searching for a value in same geneology]

Hi Mr.Barand,

 

            Thank you for your answer. I was also searching for a  recursive function. But I am not an expert in php regarding a  recursive function. So can you please show me how it look like in respect of the fields I am giving below

 

1) ID NO

2) Name

3) SPONSOR ID NO

 

Suppose I am in 100th level I need to go on checking up till I find an ID in my up lines who has qualified by introducing 3 directs. I want to fInd the person who is nearer to me above me in the genealogy AND HAS TO GIVE 5%. Please help me in this.

[Searching for a value in same geneology]

Thank You, But what I need is something else

 

1) Now on 16/07/2015 ID 1 (A) referred ID 2 (B), ID 3 © and ID 4 (D)

 

2) As he has referred 3 people he is eligible for a bonus 5% on any sales happening under him through him or through B, C AND D.

 

3) Now on 20/07/2015 ID 2 (B) also referred three people to business ID 5 (E), ID 6 (F) and ID 7 (G)

 

4) NOW ON WARDS what ever business happening under ID 2 (B) should fetch 5% only to ID 2 (B) and not to ID 1 (A).

 

5) ID 1 (A) will get 5% bonus from business happening under ID 3 © and ID 4 (D) till they also qualify by referring three persons each.

 

I am having a table called register in MYSQL. In that there is a column called user_rank. if 3 referrals are there for an ID the user_rank column will have value "YES"

 

When a new member joins the new Id has to see whether the up line or the person who sponsored him is having value YES in the user_rank column in register table. If not then it has to check whether the sponsor of his sponsor is having that , if not it has to check the sponsor's, sponsor's sponsor. This checking should go on till it finds an up line having a value YES inside the user_rank column . I am writing this coding in a php file. I need a php code for the same. Is there any loop which can go on checking rows up till the value is found. Please help me in this.

[Searching for a value in same geneology]

Suppose I am in 100th level this 5% has to go to only the person above me who qualified with introducing 5%. So i have to search back till I get an ID who has introduced 3 direct referrals. Is there any loop to do it. Or else can u just explain the coding?

[Searching for a value in same geneology]

Thank you ignace, but what i am referring is only if a introduces 3 people then he should get 5%. if the person introduced by A ( eg: B) also introduces 3 people from under his geneology 5 % will go to B not to A. How to do it?

[Searching for a value in same geneology]

I am making commission based level software. I mean it is like distributorship. If ’A’ joins the system as distributor and joins three members (B,C,D)  to the system then he should get extra 5% for every sales happening  under him or under B, C, D.  If suppose B also introduces three members( E, F, G) to the system under him then the 5% of every sales happening under B has to go to ‘B’ not to ‘A’. How can I write a coding for this in php? Here whenever a new member comes he has to check who is the one above him who is having the qualification and the 5% has to be given immediately to him automatically. Please help me in this problem.php.pdf