SQL Help Needed ! Plz. - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Other Forums

MS Access

SQL Help Needed ! Plz.

Author

Topic

toskg
Starting Member

1 Post

Posted - 2008-08-31 : 22:29:08

I am seeking an Urgent Help from all my seniors and experts to complete my assignment.

I am doing a Project for Multi-Level Marketing(MLM) Co. Website using ASP (DreamWeaver 8.0) and MS-Access as backend.

In MLM business 1 referer introduce 3 associates under his downline and earn commission against that. Again that 3 associates eachone bring another 3, and the process go one.


Its something like -
                          1001
                            |
         --------------------------------------------
        1002               1003                 1004
          |                                       |
        1005                                    1006
          |                                       |
        1010                             ----------------------
                                       1007       1008      1009

Table structure (table name: mlm)
r_id    j_id
1001    1002
1001    1003  
1001    1004
1002    1005
1004    1006
1005    1010
1006    1007 
1006    1008
1006    1009

here r_id for Referer ID & j_id for Joining ID
I was trying to create a TREEVIEW in ASP but failure.

I want to display downlines of a particular ID that entered from a ASP Form.
when I try "select * from mlm where r_id=1001" it returns only 1002,1003,1004 but 1002, 1004 again have some downlines. I want to view all inter-related data and Count the no. of downlines.
For ex.
If i query for 1003 it doesn't show any downline any count return 0.
If i query for 1004 it show 1006,1007,1008 & 1009 and count return 4.

Plz. help me. As I am new to ASP & SQL it will be better if you guide me in bit details. Also suggest me If I have to change the structure of my table.
If you want to have the project, database I can mail you also.

Thanks & Regards,
Santosh

Email: toskg@rediffmail.com

jezemine
Master Smack Fu Yak Hacker

2886 Posts

Posted - 2008-08-31 : 23:57:25

perhaps you should recruit 10 people to ask for help on your behalf.

Then they recruit 10 people each, and so on and so on. it's foolproof!

elsasoft.org

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources