Count Nested Direct Referrals Count | MYSQL, PHP


I am building a MLM website and need to be solve a SQL query using PHP which counts each user's direct referrals users.

#The Maximum Allowed Referral user is 50 (Here 50 direct referral means 50 individual chains ).

#Each chain consist of N level of users and direct referrals (each users allowed 50 direct referral).

#For better understanding please check attached snapshot.

#As per screenshot you would see 3 individual chains. in the right chain there would see two users which have 50 direct referrals and there is single user also in left chain and middle chain which have completed there 50 direct referrals.

#Suppose the top user (TOP user is completed its 50 direct referrals).

# I want to count the number of chains which have at least one user with 50 direct Referrals. (N number Deep).

#As per the screen shot we can say the top user have 3 chains which have at least one users with 50 direct referrals.

Evner: HTML, JavaScript, MySQL, PHP, Web Design

Se mere: php mysql fetch array, php mysql fetch assoc, nested count sql, recursive function in php mysql, configure mysql php troubleshoot, mysql php rental database, dumper mysql php, mysql php music database player website user system, simple display table mysql php, mysql php system creator, save xml file mysql php, simple mysql php show data dropdown, hello ajax world mysql php city states, count number jobs available user using mysql php, vote count mysql php, mysql php referrals system, count data entries mysql php, nested sortable mysql php

Om arbejdsgiveren:
( 4 bedømmelser ) bhopal, India

Projekt ID: #18237874

Tildelt til:


I'm a sql specialist, doing complex queries on oracle and / or mysql. I'm sure that is possible do what you want with a subquery in from statement. I believe that you have a good database model, but to be sure I wan Flere

$25 USD på 1 dag
(2 bedømmelser)

6 freelancere byder i gennemsnit $24 timen for dette job


Hello , I'm Tamal from Kolkata, I have 8 years exp. I'm individual work on freelancer. So, I can finish it within short time. My portfolio is : [login to view URL] My Sample: E-Commerce Projects (Online Shop Flere

$25 USD på 1 dag
(36 bedømmelser)

Hello There, I have read your requirement about MLM System. I have knowledge about it. We can discuss more in chat about the details,u can view my profile and complete on time. Regards: Webklug Thank You

$25 USD på 1 dag
(17 bedømmelser)

Hi, Please find the our demo of software. [login to view URL] Admin login : Username : admin Password : popway@506 User Lgoin: Username : F1SA00003 Password : 123456 Please message me for more details discu Flere

$25 USD på 1 dag
(3 bedømmelser)

Hi, Hope You are doing good. I have good experience with PHP, Mysql. I would like to work on this task..let's discuss it further..

$20 USD på 1 dag
(9 bedømmelser)

Hi , I can do this job, i understand your problem , it can be done 1-2 hours only. getting warning message on bid"WARNING: Do not bid on projects that ask to exchange money or cryptocurrency (e.g. Bitcoin)". I ho Flere

$25 USD på 1 dag
(0 bedømmelser)