LittleMan22
Technical User
Hi all,
I need some help with calling a value from a database on the web.
I have a database called TPG stored in the fpdb folder on my web. I also have a page ( where the user will have to enter information, and based on this information there will need to be code that retrieves the appropriate value from the database and writes it on a subsequent page.
There are 3 fields that are important (for starters):
a) sex: radio buttons coded with values 0 for male and 1 for female
b) age: needs to be derived from 3 fields (DOB month, DOB day, DOB year)
c) plan: drop down with values 5, 10, 15, 20
So based on these values, there needs to be code that goes to the database (TPG) and looks in the table called 'rates' for the cell intersection where sex= ?; age=?; plan=? and writes the corresponding value on the next page.
How do I set this up.
I really appreciate your help,
-Ryan
I need some help with calling a value from a database on the web.
I have a database called TPG stored in the fpdb folder on my web. I also have a page ( where the user will have to enter information, and based on this information there will need to be code that retrieves the appropriate value from the database and writes it on a subsequent page.
There are 3 fields that are important (for starters):
a) sex: radio buttons coded with values 0 for male and 1 for female
b) age: needs to be derived from 3 fields (DOB month, DOB day, DOB year)
c) plan: drop down with values 5, 10, 15, 20
So based on these values, there needs to be code that goes to the database (TPG) and looks in the table called 'rates' for the cell intersection where sex= ?; age=?; plan=? and writes the corresponding value on the next page.
How do I set this up.
I really appreciate your help,
-Ryan