Sample data:
id | name | referBy
----------------------------
1 admin123 0
2 king 1
3 omer123 1
4 bobb123 3
5 map1233 3
I created a function in my web application wherein users can refer other people to register.
Here is a sample image of what it looks like: 
if user map1233 will refer another user, it will be placed under him. What i want is to get the parent of the parent of the parent and so on until it goes to the main parent which is admin123..
So if map1233 will refer a user i want to get map1233, omer123 and admin123.
I was able to do that using multiple queries and if statement but the problem with that is there is a limitation of what it can reach. For example, i created 5 queries i can only get to the 5th level. What i want is to get all to all levels. Is there any way to do that using Laravel? Any Help would be appreciated. Thanks
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire