I have a form set up inside of a table with 4 columns. Let's call these columns ID, SSN, MemberType, and ZipCode. The first 3 columns are dropdown boxes pre-populated with results from 3 queries. These are also the primary key in the concerned DB table.
The 4th column - ZipCode- is a user-editable text box.
Each row in the table consists of these 4 fields.
Now my question is that since more form fields can be potentially generated after the page has been served, how would I, on submitting the form, use the form data to update the database?
The drop-downs and the text box in the first row are called 'idRow1', 'ssnRow1', 'membertypeRow1', and 'zipCodeRow1'.
Subsequently, on each generation of a new row, the fields are appended with the row#. i.e. idRow2, ssnRow2, memberTypeRow2 and zipCodeRow2. And so on.
Anyone know how to proceed?