Urgent Help Needed

[toskg]

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 -
[IMG] 1001
|
--------------------------------------------
1002 1003 1004
| |
1005 1006
| |
1010 ----------------------
1007 1008 1009[/IMG]

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: [REMOVED BY MODERATOR AS PER SITE T&CS]

[JamieHowarth0]

Hi Santosh,

Firstly, welcome to Bytes Technology Forums.

Secondly, we will not do your homework for you. We can guide you in the basic principles of what you should be aiming to achieve but we will not undertake your college work for you so you can pass off the skills and expertise of professionals as your own.

Is this classic ASP or ASP.NET? If it's ASP.NET then this would be remarkably easy to do. I don't want to see a copy of your project but I can give you guidance on where you should look and how you should think about the problem.

Best regards,

medicineworker