Hi, I have a html form that submits data (a record) to a table. However, then the next page gets loaded in with more input fields that need to be submitted to the same location in the table (it's a second part of that same record). How can I accomplish that? (I'm asking for the logic, not the script). Example:
"Pageone.html" has a text field "lastname". User fills in the last name and cgi sends data to a table "client" and creates a record: ID | Lastname | Firstname | ---------------------------------------------------- ...5 | Smith | (empty) | Then the user is taken to the next page "pagetwo.html" with a text field "firstname", fills in and submits the form. My question is: How do I tell the cgi to put the firstname in the appropriate record? (Can I submit the record via DBI and read the primary key "ID" within the same script. Other words, can I send the last name creating a new record, and then ask "what ID did you just create?". Then I could use that for the rest of my pages and keep adding data into the same record by using the unique ID. Or maybe I should use cookies somehow? But then I have to create a unique cookie so another user in the meantime doesn't have the same one - and how do I go about that?? Using large enough random number? I heard something about session ID .... Is that something I should look into? thanks for any help, Mariusz