Okay...Ive literally spent over 12 hours working on this error and Im just absolutely stumped. It has to be something simple, but Ive tried so many combinations that I cant see the forest for the trees at this point.

The goal:
When a form is submitted, a new record should be created in the table usersRegistration IF a value was supplied for uUS_REFEREE. Depending on the value supplied, determines one of the fields added in the record.

The problem:
If the value passed in $_POST[uUS_REFEREE] is a "7", this script is creating 2 identical entries in the table. If the value passed is a "4", it makes a single entry like its supposed to. What am I missing here?!?

Here is the processing code where this is supposed to occur:

PHP Code: ############### IF THE POST VALUE NOT EMPTY, CREATE A RECORD BASED ON THE PASSED VALUE##########
if(!empty($_POST[uUS_REFEREE])){
    
    if($_POST[uUS_REFEREE]==7){$VAR[uRegAction] = upgrade;}
    if($_POST[uUS_REFEREE]==4){$VAR[uRegAction] = new;}
    
    // CREATE REGISTRATION RECORD
        include(../classes/databaseConnection.php);
            $sql300 =
                INSERT INTO usersRegistration (uRegID,uRegYEAR,uRegCLASS,uRegGRADE,uRegTYPE,uRegSTATE,uRegUID,uRegFIRST,uRegMIDDLE,uRegLAST,
                uRegADDRESS,uRegCITY,uRegADDRSTATE,uRegZIP,uRegPHONE1,uRegEMAIL,uRegNATIONBIRTH,uRegNATIONCITIZEN,uRegBIRTHDATE,uRegGENDER,uRegDISTRICT,uUSID,
                uRegPAYMETHOD,uRegPAYAMOUNT,uRegSTATUS,uRegBATCHID,uRegFELONY,uRegFELONYDESC,uRegFELONYDATE,uRegACTION,uRegUPDATE,
                uRegFIRSTREGISTERED,uRegDATE,uRegSIG)
                VALUES (,$VAR[regyear_year],Referee,$_POST[uUS_REFEREE_GRADE],,CO,$_GET[id],$_POST[uFIRST],$_POST[uMIDDLE],$_POST[uLAST],
                $_POST[uADDRESS],$_POST[uCITY],$_POST[uSTATE],$_POST[uZIP],$_POST[uPHONE1],$_POST[uEMAIL],
                $_POST[uNATIONBIRTH],$_POST[uNATIONCITIZEN],$VAR[uBIRTHDATE1],$_POST[uGENDER],,,OFF,
                - ADMIN -,submitted,,$_POST[uFELONY],$_POST[uFELONYDESC],
                $_POST[uFELONYDATE],$VAR[uRegAction],,$_POST[uUS_REFEREE_GRADEDATE],$VAR[today],x
                );
            $result300 = mysql_query($sql300,$connection)or die(mysql_error());
    

}
Thanks very very very much in advance for any assistance in seeing what I cannot! Okay...Ive literally spent over 12 hours working on this error and Im just absolutely stumped. It has to be something simple, but Ive tried so many combinations that I cant see the forest for the trees at this point.

The goal:
When a form is submitted, a new record should be created in the table usersRegistration IF a value was supplied for uUS_REFEREE. Depending on the value supplied, determines one of the fields added in the record.

The problem:
If the value passed in $_POST[uUS_REFEREE] is a "7", this script is creating 2 identical entries in the table. If the value passed is a "4", it makes a single entry like its supposed to. What am I missing here?!?

Here is the processing code where this is supposed to occur:

PHP Code: ############### IF THE POST VALUE NOT EMPTY, CREATE A RECORD BASED ON THE PASSED VALUE##########
if(!empty($_POST[uUS_REFEREE])){
    
    if($_POST[uUS_REFEREE]==7){$VAR[uRegAction] = upgrade;}
    if($_POST[uUS_REFEREE]==4){$VAR[uRegAction] = new;}
    
    // CREATE REGISTRATION RECORD
        include(../classes/databaseConnection.php);
            $sql300 =
                INSERT INTO usersRegistration (uRegID,uRegYEAR,uRegCLASS,uRegGRADE,uRegTYPE,uRegSTATE,uRegUID,uRegFIRST,uRegMIDDLE,uRegLAST,
                uRegADDRESS,uRegCITY,uRegADDRSTATE,uRegZIP,uRegPHONE1,uRegEMAIL,uRegNATIONBIRTH,uRegNATIONCITIZEN,uRegBIRTHDATE,uRegGENDER,uRegDISTRICT,uUSID,
                uRegPAYMETHOD,uRegPAYAMOUNT,uRegSTATUS,uRegBATCHID,uRegFELONY,uRegFELONYDESC,uRegFELONYDATE,uRegACTION,uRegUPDATE,
                uRegFIRSTREGISTERED,uRegDATE,uRegSIG)
                VALUES (,$VAR[regyear_year],Referee,$_POST[uUS_REFEREE_GRADE],,CO,$_GET[id],$_POST[uFIRST],$_POST[uMIDDLE],$_POST[uLAST],
                $_POST[uADDRESS],$_POST[uCITY],$_POST[uSTATE],$_POST[uZIP],$_POST[uPHONE1],$_POST[uEMAIL],
                $_POST[uNATIONBIRTH],$_POST[uNATIONCITIZEN],$VAR[uBIRTHDATE1],$_POST[uGENDER],,,OFF,
                - ADMIN -,submitted,,$_POST[uFELONY],$_POST[uFELONYDESC],
                $_POST[uFELONYDATE],$VAR[uRegAction],,$_POST[uUS_REFEREE_GRADEDATE],$VAR[today],x
                );
            $result300 = mysql_query($sql300,$connection)or die(mysql_error());
    

}
Thanks very very very much in advance for any assistance in seeing what I cannot!

View Complete Thread with Replies