Startpage->ProcessPage->DisplayPage?

[Timm]

I have a start page that collects user input to build a database insert query. Currently, that data is passed to a processing page which is also used to display the data. Unfortunately, if the user refreshes this processing page, the data is resubmitted to the database and a new record is created using the next auto-increment ID number.

When the user clicks the submit button on the start page, is there a way to send the data to the processing page, have the processing page send the data to a display page (without the user having to click a second submit button), and--if the user clicks the back button from the display page--to have the browser take the user back to the start page instead of to the processing page so that virtually duplicate records do not get created in the database as a result of the processing page being re-displayed?

Thanks!

Timm

[feldon23]

I'm thinking you could use sessions or cookies to keep indicate that an "add_record" is in progress and to not allow a 2nd one to be issued from the computer until the 1st one is complete.

[Timm]

I am using sessions, and I added an "AddRequest" hidden field with a default value of "Yes" to the start page.

This variable is passed to the processing page and registered using: $HTTP_SESSION_VARS["AddRequest"]=$AddRequest;

My insert query is now preceded by the following code:
If ($AddRequest=="Yes") {
$AddRequest="No";

Somehow, I am still getting 2 copies of the same record. When the page first displays, I get the record I expect to get. When the page is refreshed, I get a second copy (with a different auto-increment number). If I refresh the page a third time, I don't get another copy of the record.

What do I need to do to keep from getting the second copy?

Thanks!

Timm