watsmyname Posted August 2, 2009 Share Posted August 2, 2009 Hello friends, i m moderate in sql, or you can say not that good. I m developing multilevel marketing or network marketing web application, but I've been banging my head creating a database structure. Brief concept is listed below so anybody enlighten me with how i should start. 1. A member creates their account, suppose his username is "abc" 2. Other members are being referred by "abc" 3. There are many levels of members. 4. "abc" has suppose pqr, xyz, mno in first level (these three are being referred by abc) 5. again pqr might have tuv,wxy,rst,zab, etc this is first level for pqr and 2nd level for user abc. 6. now again tuv has 6 members, this is first level for tuv, 2nd level for pqr and 3rd level for abc. 7. Now the user abc gets commissions for the member he created and the members created by his members. He gets commissions for upto 4 levels. All i want is to create a member table so that i can keep track of these members and i can easily find the members upto 4 levels. Can anybody enlighten me? i will be really grateful thanks watsmyname Quote Link to comment https://forums.phpfreaks.com/topic/168515-getting-crazy-while-making-db-structure-for-network-marketing/ Share on other sites More sharing options...
fenway Posted August 3, 2009 Share Posted August 3, 2009 You're talking about storing hierarchical data... there many resources available, including some in the stickies. Quote Link to comment https://forums.phpfreaks.com/topic/168515-getting-crazy-while-making-db-structure-for-network-marketing/#findComment-889981 Share on other sites More sharing options...
watsmyname Posted August 4, 2009 Author Share Posted August 4, 2009 You're talking about storing hierarchical data... there many resources available, including some in the stickies. Thanks for the reply fren, it would have been much easier if you've provided me the link to such resources or stickies, i dont know where to find or with what keyword i should search. thanks aagain Quote Link to comment https://forums.phpfreaks.com/topic/168515-getting-crazy-while-making-db-structure-for-network-marketing/#findComment-890209 Share on other sites More sharing options...
roopurt18 Posted August 4, 2009 Share Posted August 4, 2009 http://dev.mysql.com/tech-resources/articles/hierarchical-data.html http://www.google.com/search?q=storing+hierarchichal+data Quote Link to comment https://forums.phpfreaks.com/topic/168515-getting-crazy-while-making-db-structure-for-network-marketing/#findComment-890220 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.