Auto Increment Field and POST data
First off, thanks to everyone for your help here on this forum....it is very valuable.
My question today is about grabbing an Auto Increment field in POST data.
If someone fills out a form, then clicks on the button to submit the form (and open a new form detailed in the Action), I have some questions about the POST data from the first form:
If the table data I am collecting is StudentData, in the StudentData table is an Auto Increment field StudentID. If I am having the person fill in the name and address fields etc, then click submit, how do I get StudentID on the next form through POST?
It seems to me that the table is not updated until they click the button right? So how can I POST a piece of data that isnt available until AFTER they click that button?
Here is what I am asking:
Page1, Form1 = Data Insert into StudentData table using Dreamweaver's Insert>Data Objects > Insert Record > Insert Record Wizard. Here is the form action code:
<form action="<?php echo $editFormAction; ?>" method="post" name="form1" id="form1">
In Page1, I am using a recordset called rsStudentData.
Within the StudentData table is an auto increment field "StudentID". In the query that creates rsStudentData, I have not selected the StudentID field at all.
Page2: How do I grab the POST data for the StudentID field? I have not used in the the Recordset of Page1, so how can I grab the field?
I appreciate any help you can provide!
-CL
