Find Jobs
Hire Freelancers

Count Nested Direct Referrals Count | MYSQL, PHP

$10-30 USD

Selesai
Dibuat lebih dari 5 tahun yang lalu

$10-30 USD

Dibayar ketika dikirim
Hello, 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.
ID Proyek: 18237874

Tentang proyek

6 proposal
Proyek remot
Aktif 5 tahun yang lalu

Ingin menghasilkan uang?

Keuntungan menawar di Freelancer

Tentukan anggaran dan garis waktu Anda
Dapatkan bayaran atas pekerjaan Anda
Uraikan proposal Anda
Gratis mendaftar dan menawar pekerjaan
Diberikan kepada:
Avatar Pengguna
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 want to know how do you store the referalls of an user on database.
$25 USD dalam 1 hari
5,0 (2 ulasan)
1,2
1,2
6 freelancer menawar dengan rata-rata $24 USD untuk pekerjaan ini
Avatar Pengguna
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 dalam 1 hari
5,0 (17 ulasan)
4,4
4,4
Avatar Pengguna
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 dalam 1 hari
5,0 (9 ulasan)
3,2
3,2
Avatar Pengguna
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 hope you will pay amount not in Bitcoin than only i am ready to do. Regards, Gaurav
$25 USD dalam 1 hari
0,0 (0 ulasan)
0,0
0,0

Tentang klien

Bendera INDIA
bhopal, India
5,0
4
Memverifikasi Metode pembayaran
Anggota sejak Jan 26, 2009

Verifikasi Klien

Terima kasih! Kami telah mengirim Anda email untuk mengklaim kredit gratis Anda.
Anda sesuatu yang salah saat mengirimkan Anda email. Silakan coba lagi.
Pengguna Terdaftar Total Pekerjaan Terpasang
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Memuat pratinjau
Izin diberikan untuk Geolokasi.
Sesi login Anda telah kedaluwarsa dan Anda sudah keluar. Silakan login kembali.