MySql PHP tree view -


I am creating a web application for an affiliate program and on my user table It has the structure:

showing the picture

This MySql Depending on the table, every user should be able to see his tree, so I need this question:

  1. To see the user who recruited him and by whom Was Rti and I do not know that the query is admitted to such other users to show who was admitted to the user's recruitment. Basically it should look like this:

Showing pictures .. If your table structure looks really like this, maybe some queries might be?

< / P>

It shows that in this article this recursive and other logs Deals with a.


Comments

Post a Comment