rubysymal

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.

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.

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?

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?

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