Hi, I'm Rane and I need some helps!
I have a member table in MySQL database. Each member have a 'referralID' which indicate their respective referral. The 'referalID' is refer to 'MemberID' field, that is, the referalID must be an existed valid MemberID in the table.
For example: C is a new member, his referal is B who have 5 subsidiary(C,D,E,F,G). B's referal is A and so on and so forth.
A
|
B
____|______
| | | | |
C D E F G
Now I have to write PHP program to retrieve these information from the database and draw the network diagram to the browser(by automatically).
I'd write the code to retrieve all members form the table and now I'd stuck here for a day!
Please do help me! Thank you.
😕 :mad:
