Duplicate SQL Entry Error

Hi I have created this script to add Airfield information to a database using a form, it works OK except that I always get a duplicate entry int the database. Can someone tell me how I just get a single entry in.
I am not a .php programmer, I have just thrown this together using examples and tutorials. I am sure it is a simple error in the code but I cannot spot it.

[php]<?php

$page_title = ‘Add airfield’;
$page_heading = ‘Add Airfield’;

include(‘includes/header.php’);

echo ‘

Insert New Airfield Record

’;

$_id = getVar(‘id’);

// if user isn’t logged in as admin
if (! $user_info[‘is_admin’]) {
ssi_login (BASE_HREF . ‘addairfield.php’, ‘echo’);
include(‘includes/footer.php’);
exit(0);
}

$_submit = getVar(‘submit’);
$_icao = getVar(‘icao’);
$_airfieldName = getVar(‘airfieldName’);
$_lat = getVar(‘lat’);
$_lon = getVar(‘lon’);
$_elevation = getVar(‘elevation’);
$_mainRunwayHeading = getVar(‘mainRunwayHeading’);

if ($_submit == ‘Add Record’) {
// setup SQL statement
$sql = “INSERT INTO glider_fields SET icao=’” . $_icao . “’, name=’” . $_airfieldName . “’, lat=’” . $_lat . “’, lon=’” . $_lon . “’, elevation=’” . $_elevation . “’, main_rwy=’” . $_mainRunwayHeading . “’”;

    // execute SQL statement
    $result = mysql_query($sql);

    // check submission
if( ($result = mysql_query($sql, $GLOBALS['db']))  and  (mysql_affected_rows($GLOBALS['db']) == 1) )  {
	echo '<p>Successfully added ' . $_name . ' (' . $_icao . ') to airfield database.</p>';
}
else  {
	echo '<p>Error adding ' . $_name . ' (' . $_icao . ') to airfield database!</p>';
}

}

echo ‘’;
echo ‘

’;
echo ‘’;
echo ‘’;
echo ‘’;
echo ‘’;
echo ‘’;
echo ‘’;
echo ’ ';
echo ‘
ICAO:
Airfield Name:
Latitude (Dec Minutes):
Longitude (Dec Minutes):
Elevation (Feet ASL):
Main Runway Heading:
 
’;
echo ’ ';

include(‘includes/footer.php’);

?>[/php]

Fixed
I removed the first $Result statement as I had to of these in the script causing the duplicate.

Good job finding it :slight_smile:

Sponsor our Newsletter | Privacy Policy | Terms of Service