Hi Linda,
What type of database are you using? and Programming language?...
Generally you can do a select statement with the questions and select box
entries being in the "Where" clause to determine what to display.
ie SELECT * FROM Users WHERE Name = Question1Answer and Status =
SelectBox1Answer
In your code page (asp, php etc) you would request u'r form variables, put
the query string together, open up a "recordset", and pass the string to
the "recordset" to get u'r results back.
I don't know how complex your questionare is, and/or what u'r data
structure is like and all the other above mentioned variables. So its a bit
difficult to explain.
:)
Sonja van der Westhuizen
Tel.: 011 282-1843
Fax: 011 282-4529
Cell: 083 256 0810
email: [EMAIL PROTECTED]
|--------+------------------------->
| | Linda Wells |
| | <[EMAIL PROTECTED]|
| | roint.com> |
| | |
| | 2003/10/01 |
| | 10:38 AM |
| | Please respond |
| | to wdvltalk |
| | |
|--------+------------------------->
>---------------------------------------------------------------------------------------------------------------------------------------------|
|
|
| To: [EMAIL PROTECTED]
|
| cc:
|
| Subject: [wdvltalk] collecting info to query database
|
>---------------------------------------------------------------------------------------------------------------------------------------------|
Hello list,
I need to create a page that presents a number of questions and them on the
basis of the answers send a query to a database to return the appropriate
data.
I have got as far as the questions and drop down lists for selection of the
answers and now I am stuck. I don't know how to turn the selections into
something I can use for the database query part. I don't know much about
database queries either :(
I am just going to start searching for some tutorials etc but if you can
help with hints, tips or examples it would be very much appreciate as I am
supposed to finish this by Friday.
Linda
************************************************************************
This Internet E-mail is intended solely for the person to whom it is
addressed. It may contain confidential or privileged information. If you
have received it in error please notify us immediately by telephone and
destroy the transmission. You must not copy, distribute or take any action
in reliance on it.
Aerosystems International Phone: +44 (0)1935 443000
Fax : +44 (0)1935 443111
Web : www.aeroint.com
************************************************************************
____ ? The WDVL Discussion List from WDVL.COM ? ____
To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED]
Send Your Posts To: [EMAIL PROTECTED]
To set a personal password send an email to [EMAIL PROTECTED] with the
words: "set WDVLTALK pw=yourpassword" in the body of the email.
To change subscription settings to the wdvltalk digest version:
http://wdvl.internet.com/WDVL/Forum/#sub
________________ http://www.wdvl.com _______________________
You are currently subscribed to wdvltalk as:
[EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
____ � The WDVL Discussion List from WDVL.COM � ____
To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED]
Send Your Posts To: [EMAIL PROTECTED]
To set a personal password send an email to [EMAIL PROTECTED] with the words: "set
WDVLTALK pw=yourpassword" in the body of the email.
To change subscription settings to the wdvltalk digest version:
http://wdvl.internet.com/WDVL/Forum/#sub
________________ http://www.wdvl.com _______________________
You are currently subscribed to wdvltalk as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
