insert record twice

DJH

When running the following code the record gets inserted twice. Can somebody please tell me where I am going wrong. Many Thanks

<?php

$conn = mysqli_connect("localhost","root","XXXXXX","test");
    if (mysqli_connect_errno()) {
        printf("Connect failed: % s/n", mysqli_connect_error());
        exit();
    } else{

    $gamedate = '2012-1-01';

    $sql = "INSERT INTO fixtures (gamedate)
		 Values('$gamedate')";

    $res = mysqli_query($conn,$sql);

        if ($res === TRUE) {
            echo "The record has been inserted";
        } else{
            printf("Could not insert the record: %s\n", mysqli_error($conn));
        }
}
mysqli_close($conn);

DJH

Hi Further to my previous comment, when running this code a second or third time, it still adds two records , however the gamedate value always shows 2012-1-01 for the first of the records and the new value for the second of the records.

johanafm

This code only inserts once. The problem is to be found elsewhere.

sneakyimp

It may be that you are refreshing the page that inserts the record somehow -- or clicking 'back' in your browser or something. If the insert code is run in response to a form post or run when the user loads a particular page, you might want to put in a META refresh tag that redirects to a page that does not reinsert the data -- like this forum does when you post in a thread.