vny_009 — 2013-05-01T01:30:38-04:00 — #1
I want to make multi level referral system in that if A,B, C,D,E are registered user of a site then B is referred by A and C is referred by C and so on. In my site there is system for earning incentive. I want to show how much money A has earned through B and B through C and likewise.
I want simply show referrals name and their number in A's profile and portion of money earned from each referral.
i have downloaded a script from this site. The demo is here:http://scripts.kunals.com/index.php?page=d/item/demo/index&itmid=1
And i have two types of users in my site: normal user and premium user. I want to generate ref id only for premium users. what will be the table structure?
vny_009 — 2013-05-03T11:49:12-04:00 — #2
very sad to see that no replies till now...if anybody have some idea please share with me.
captainccs — 2013-05-03T13:06:57-04:00 — #3
This not a php problem but a relational database problem, how one user is related to other users. Assuming that each user is referred by only one user you just need a "referred_by_id" field and a good use of MySQL queries should return all the results you need.
This thread might get better answers at the database board.
vny_009 — 2013-05-03T14:28:06-04:00 — #4
thanks for your reply. I asked here because i have a script and today i made another script which comprises several nested while loop. Now question is that using several nested loop can be safe i mean no problem on server speed if more users visit that page.
Because this would be used on social networking site.