to retreive form values on basis of an id

kashsheikh · November 22nd, 2004, 08:53 AM

hi

i want to retreive values from a databse on the basis of an Id. & i want to use those values to add other form values in that particular Id.

for example
Db table has 6 cols. i have entered 3 values in them usin a form & then post it. on the next page i want to enter in the remaining 3 fields having Id=1. ANy ideas Need Help

happygv · November 22nd, 2004, 02:33 PM

Hi,

Quote:

quote:for example
Db table has 6 cols. i have entered 3 values in them usin a form & then post it. on the next page i want to enter in the remaining 3 fields having Id=1. ANy ideas Need Help

Could you explain little more on that? Is that you want to retrieve data based on ID=1 or you are trying to add values for those remaining 3 cols for the row that has ID=1?

If you are looking for retrieving values based on ID, query the database based on ID=1

Code:

SELECT col1, col2, col2 FROM tablename WHERE ID=1

Hope that helps.
Cheers!

_________________________
- Vijay G
Strive for Perfection

kashsheikh · November 23rd, 2004, 10:15 AM

yeah that helped a bit thanx

kashsheikh · November 23rd, 2004, 10:17 AM

now can u tell me one more thing i want to Retreive data from DAtabase & show them in a field as an editable field,
for e.g i have to show a menu & to get that value from the menu that was chosen by the user when they submitted the form

happygv · November 23rd, 2004, 02:56 PM

Not sure if I understood that right. What kind of menu is that? Are you looking for ASP code that would extract the value that was submitted to a form?

Can you explain more on that?

Cheers!

_________________________
- Vijay G
Strive for Perfection

kashsheikh · December 1st, 2004, 11:32 AM

i have solved it thankyou for the help