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]
1  1572 
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
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: choksi |
last post by:
Hello All
I am running PHP5.0.2 over apache 1.3.29 and openssl-0.9.7d on a Debian
Linux and with a fake (internal)ip.
Php Configure command './configure' '--with-apxs=/www/bin/apxs'
'--with-openssl-dir=/usr/local/src/webserver/openssl-0.9.7d/'
'--enable-trans-sid' '--disable-libxml'
Registered PHP Streams : php, file, http, ftp
Registered Stream Socket Transports : tcp, udp, unix, udg
allow_url_fopen : ...
|
by: Tony Archer |
last post by:
Gentlemen, your urgent help is needed in solving a STRANGE problem.
I have two servers a dev box, and a production box. On the dev box
everything works fine, in production it hoses:
One of the things a user can do is click a "Change region" link which takes
them to a map of the world. They can then select one of four regions.
When they select a region it takes them to a page which reads a variable and
then sets a cookie which is...
|
by: Tony Archer |
last post by:
(Forgive the dupicate post, I had left out the OS Version out of the prior
post.)
Gentlemen, your urgent help is needed in solving a STRANGE problem.
I have two servers a dev box, and a production box. On the dev box
everything works fine, in production it hoses:
One of the things a user can do is click a "Change region" link which takes
them to a map of the world. They can then select one of four regions.
|
by: felix_william |
last post by:
Attention=3A Dear friend=2C
REQUEST FOR BUSINESS RELATIONSHIP OF GREAT PROFITS
I am HON=2E =28DR=2E=29 Felix William=2C the Director of Procurement and Contract Award at the Nigerian National Petroleum Corporation =28NNPC=29 of the Federal Republic of Nigeria=2E I apologized using this medium to reach you for a transaction=2F business of this magnitude=2C but this is due to Confidentiality and prompt access reposed on this medium=2E It is...
|
by: Vibhajha |
last post by:
Hi friends,
My sister is in great problem , she has this exam of C++ and
she is stuck up with some questions, if friends like this group
provides some help to her, she will be very grateful.
These are some questions:-
7. design and implement a class binsearch for a binary search tree.it
includes search,remove and add options.make suitable assumption.
8.explai how pointers to functions can be declared in c++.under what
conditions can...
| | |
by: Random |
last post by:
The way I've built my page is to take the user through a multi-form process,
only rendering those controls that are needed for each section. The
ViewState is working the way I want it to, remembering items across the
process, back and forth. But when the user finally opts to complete the
sections and commit the information for processing, I can't access any of
the information that was not rendered on the last section. It's obviously
in...
|
by: meenasamy |
last post by:
Hi all, i need to create a function that takes three parameters(
Original currency, needed currency, amount) i need to convert from the
original currency to the needed currency the amount and return the new
amount in the needed currency, I need this function to work real time
(obtaining real time currency exchange rates), any ideas???
|
by: N. Spiker |
last post by:
I am attempting to receive a single TCP packet with some text ending with
carriage return and line feed characters. When the text is send and the
packet has the urgent flag set, the text read from the socket is missing the
last character (line feed). When the same text is sent without the urgent
flag set, all of the characters are read.
I'm reading the data using the blocking read call of the network stream
class. The .NET...
|
by: Preetam Pattanashetty |
last post by:
Hi
I am learning ASP.NET using C#. I am able to run .aspx files on local system, but when I load them to the server, I get the "Server Error in '/' Application" error. I have tried to configure the web.config file but has not been fruitful.
I would be thankful if the following questions were answered:
a)has the write permissions on files and folders have to do something with it?
b)what role does asp_client folder play?
c) What other...
|
by: Christopher |
last post by:
Urgent Help Needed: The EPVH-1.1 Visual Hull Library.
Dear All,
I am a student doing research in computer vision. The EPVH-1.1 Visual
Hull Library will really help a lot in my research.
I did have this library before but I didn't keep my copy of this
library because I always thought I could download it again form
internet. However, the author of this library closed the download
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| | |
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
