MySQL Forums
Forum List  »  PHP

Best Mysql structure
Posted by: William Glenn
Date: June 17, 2013 11:10AM

Ok all I need some quick help on this one.

I have a table say

ID, FirstName, LastName, Recruiter_ID

Which contains a rep's information and the ID of the person recruiting from the same table.. So let's take an example

ID 1000 recruits 1001, and 1001 recruits 1002 but 1000 needs to get credit for the whole volume 1001 and 1002 create.

So
1000
|
1001
|
1002
1003
1004
|
1005
1006
etc.

What would be the best structure to find all of the ID's of recruits brought on by anyone under 1001?

Hope this makes sense?

Thanks!
William

Options: ReplyQuote


Subject
Written By
Posted
Best Mysql structure
June 17, 2013 11:10AM
June 19, 2013 10:51PM
June 19, 2013 11:38PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.