Click refresh re-executes db insert

[chuender]

I have a page which allows users to add a new contact to the database. On complete of this add, the user is taken to the contact list page, which lists all the contacts. That part works.

However, the problem occurs when user then clicks Refresh, on the contact list page, and the page refreshes and a duplicate contact is created.

How would I resolve this.

Thanks for your help.

[leatherback]

Several methods are possible:

• Do a query to the database before insderting: Check wether a matching recors exists in the database, possibly with matching date, if you store the reg. data
• Set a session variable to true if the data was stored: People need to logout before they can re-enter their data.

[byp]

try the second option that leatherback said like this:

//start session, <- on top of page
session_start();

if(isset($_SESSION['contact_loaded'])){
    echo  "the contact was already loaded";
}else {
    $_SESSION['contact_loaded'] = true;

//put contact in database
mysql_querry("INSERT INTO ............");
}