Find Jobs
Hire Freelancers

MYSQL: Hierarchical Tree (3 levels) in one table

$10-30 USD

Anulat
Data postării: peste 5 ani în urmă

$10-30 USD

Plata la predare
Hi. I have a WordPress table with users and usermeta. Every user has an ID and nearly every user has a sponsor_id. Now I need a list of all user IDs (3 levels deep) from a specific ID. For example: I want all three levels from the user with the ID 1: user 202: sponsor_id = 1 (1. level) user 245: sponsor_id = 1 (1. level) user 355: sponsor_id = 1 (1. level) user 410: sponsor_id = 245 (2. level) user 425: sponsor_id = 355 (2. level) user 533: sponsor_id = 1 (1. level) user 568: sponsor_id = 425 (3. level) And so on. I need a list of IDs of all of them (3 levels deep).
ID-ul proiectului: 17265411

Despre proiect

17 propuneri
Proiect la distanță
Activ: 6 ani în urmă

Vrei să câștigi bani?

Avantajele de a licita pe platforma Freelancer

Stabilește bugetul și intervalul temporal
Îți primești plata pentru serviciile prestate
Evidențiază-ți propunerea
Te înregistrezi și licitezi gratuit pentru proiecte
Acordat utilizatorului:
Avatarul utilizatorului
I have read it and ready to start right now..............................................................................................................
$20 USD în 1 zi
5,0 (129 recenzii)
6,2
6,2
17 freelanceri plasează o ofertă medie de $30 USD pentru proiect
Avatarul utilizatorului
Dear Sir/Mam, I am very much interested to do the job. I am expert web developer with more than 15 years of professional experience. I can write the mysql query which will return records as per the hierarchy you have specified. Given a speicific ID it will show all children upto 3rd level in a list. I can do this right away. If you accept then please contact me so we can proceed. Thanks, Hammad
$25 USD în 1 zi
5,0 (351 recenzii)
7,4
7,4
Avatarul utilizatorului
Hi, I'm a full-stack developer with more than 10 years of work experience. Expert in BOTH Backend and Front-end Programming, PHP - OOP, MVC, REST API, HTML/CSS/JAVASCRIPT, Wordpress Theme Integration, Woocommerce/Ecommerce, Magneto,Shopify, Responsive Design, Plugin Development, Adaptive websites, White Hat SEO, Android and IOS App Development. I look forward to a successful working relationship in the future. Kind Regards, Vivek
$25 USD în 1 zi
4,7 (100 recenzii)
6,4
6,4
Avatarul utilizatorului
Hi there..... Warm Greetings We came along with your request for MYSQL: Hierarchical Tree (3 levels) in one table and we reviewed your project description. We'd like to help you with confidence and satisfying results... We have professionals working here with 100% results and more creative and renovative ideas for our clients ! We have worked on several similar projects before! We are offering our services for more than 5 years in the field of MySQL, WordPress We have worked on 350+ Projects. Please check the profile reviews Feel free to message us to discuss briefly about your project !
$50 USD în 1 zi
4,6 (13 recenzii)
4,8
4,8
Avatarul utilizatorului
i can do this, have a lot of experience and can bring a good result for you..... i will take the cheap rate but good service for you................ very much interested for this project............ and want to build a long term relation with you by my service....................
$30 USD în 1 zi
5,0 (6 recenzii)
2,7
2,7
Avatarul utilizatorului
Hi, I am an experienced 5 year experience php developer i will do your project with minimum amount and with maximum quality
$10 USD în 0 zi
5,0 (5 recenzii)
2,4
2,4
Avatarul utilizatorului
Hi i can provide you that query that will run until 3 level deep i have already strong experience with wordpress database where we have info in key value pair i am very much interested to solve your issue
$25 USD în 1 zi
5,0 (7 recenzii)
2,4
2,4
Avatarul utilizatorului
I have already worked for this for some freelancer in hierarchical fasion with basic code level if you want , please ping me and let me know your table schema , i will finish and give you
$45 USD în 1 zi
3,8 (1 recenzie)
2,0
2,0
Avatarul utilizatorului
We are a team of some of the greatest minds in Web. We are incredibly passionate about and take pride in what we do. Our team collectively has a proven track record of successfully delivering 100+ software solutions to U.S, U.K, Pan Pacific etc. clients. Our field of expertise: • UI/UX Design • PHP • CodeIgniter Framework • AnjularJS • jQuery • WordPress Developing industry best solutions at very reasonable price is our forte. We strive for perfection and excellence to achieve great things and make a positive lasting mark in the industry. We place a high value on personal integrity, ethical approach and value for money. We will meet all your requirements, maintaining quality and your expectations. Our motto is "Your Success Is Our Success"
$25 USD în 1 zi
0,0 (0 recenzii)
0,0
0,0

Despre client

Steagul AUSTRIA
Klagenfurt, Austria
4,9
14
Metoda de plată a fost confirmată
Membru din mai 15, 2017

Verificarea clientului

Mulțumim! Ți-am trimis prin e-mail linkul pe care trebuie să-l accesezi pentru a revendica creditul gratuit.
A apărut o eroare la trimiterea e-mailului. Încearcă din nou.
Utilizatori înregistrați Totalul proiectelor postate
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Se încarcă previzualizarea
S-a oferit permisiunea de depistare a locației.
Ți-a expirat sesiunea pentru conectare sau te-ai deconectat. Conectează-te din nou.