Link to home
Start Free TrialLog in
Avatar of umaxim
umaximFlag for United States of America

asked on

SQL Query

I need to make a sql query which will take out from mysql table people by reference for example i have 2 row one is id and another is invite

So when for example one user register he get invite and he can invite 2 people who at the same time get the same.

So i need to make a relationship table like first user -> invited user -> invited user so it look like pyramid. I know hot to make it by taking all users and using php but is it any way i can do it using mysql
Avatar of ralmada
Flag of Canada image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of umaxim


This table what u give me is using 3 tables. But i need to make it using one table. I need to search inside on it.