Problem with Form - Insert - Back Button ...

[tanaka99]

I have a form that I use to collect information from users. I pass the variables from this form to an insert page to insert this data into my database. My problem is ... after I've inserted the data and I leave the INSERT page 'Thank You' message ... if I hit the back button and go back to the insert page it resubmits the data creating a new record with the same data in the database.

How can I keep this from happening? Thank you.

[OhLordy]

You could do a select just before you insert to check if there is already a record with that data in the database and disallow the insert if there is.
Also you could set a session variable when the data is inserted and if the insert page is revisited within, say 10 mins, the page automatically redirects, or at least prompts the user to make sure they want to be submiting the form again.

HTH
Rob

[tanaka99]

Could you provide a blanket sample of the select statement you'd use to check if the data already exists?

[OhLordy]

<?
$sql="select * from table where condition";
$result=mysql_query($sql,$conn);
if(mysql_num_rows($result)>0)
{
  echo("There is already this form of data in the database. Are you sure?");
}
else
{
  //insert the data
}
?>

HTH
Rob