Skip navigation links

MySQL Forums :: PHP :: Best Mysql structure


Advanced Search

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 William Glenn 06/17/2013 11:10AM
Re: Best Mysql structure Rick James 06/19/2013 10:51PM
Re: Best Mysql structure Peter Brawley 06/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.