ID;

    $S_ID = 16;
    $Car = “Late Model”;
    $Case = $_POST[“Case”];

    $sql = “SELECT * FROM series s INNER JOIN colors c WHERE s.Series_ID = $S_ID”;
    $result = mysql_query($sql)
    or die(“Couldn’t execute query 10.”);
    $row = mysql_fetch_array($result);
    extract($row);
    ?>

    1000)
    {
    ltrim($First,’99’);
    }

    $Second = $_POST[“SecondNum”];

    if($Second > 1000)
    {
    ltrim($Second,’99’);
    }

    $Third = $_POST[“ThirdNum”];

    if($Third > 1000)
    {
    ltrim($Third,’99’);
    }

    $Nickname = $_POST[“Nickname”];
    $Bday = $_POST[“Bday”];
    $Hometown = $_POST[“Hometown”];
    $Team = $_POST[“Team”];
    $Sponsor = $_POST[“Sponsor”];
    $Num_Req = $First . “, ” . $Second . “, ” . $Third;

    $Driver_ID = $_POST[“D_ID”];

    $sql = “SELECT iCust_ID as ID_Check, Driver_ID FROM drivers WHERE iCust_ID = $iCust”;
    $result = mysql_query($sql)
    or die(“Couldn’t execute query 75.”);
    $num = mysql_num_rows($result);

    ### If Driver exists
    if($num>0)
    {

    $row = mysql_fetch_array($result);
    extract($row);

    $sql = “UPDATE drivers SET Nickname=’$Nickname’,Hometown=’$Hometown’,DOB=’$Bday’,Email=’$Email’ WHERE iCust_ID = $iCust”;
    mysql_query($sql);

    }

    ### If Driver is new
    if($num==0)
    {

    $sql = “INSERT INTO drivers (Name,Email,Nickname,Hometown,DOB,iCust_ID) VALUES (‘$iName’,’$Email’,’$Nickname’,’$Hometown’,’$Bday’,’$iCust’)”;
    mysql_query($sql);

    $sql = “SELECT Driver_ID FROM drivers WHERE iCust_ID = ‘$iCust'”;
    $result = mysql_query($sql)
    or die(“A MySQL error has occurred.
    Your Query: ” . $your_query . “
    AError: (” . mysql_errno() . “) ” . mysql_error());
    $row = mysql_fetch_array($result);
    extract($row);

    $Rookie = 1;

    }

    $sql = “INSERT INTO driver_detail (Driver_ID,Series_ID,Team,Sponsor,Num_Req,Rookie) VALUES (‘$Driver_ID’,’$S_ID’,’$Team’,’$Sponsor’,’$Num_Req’,’$Rookie’)”;
    mysql_query($sql);

    $sql = “INSERT INTO driver_stats (Driver_ID,Series_ID) VALUES (‘$Driver_ID’,’$S_ID’)”;
    mysql_query($sql);
    ?>
    Your application is very important to us and will be reviewed soon.
    You will appear on the Driver Roster after your application has been approved.
    Thank for your interest and support of the Upstate Racing League!

    \n”;
    echo “

    \n”;

    ?>
    New Driver\n”;

    $sql = “SELECT d.Name, d.Driver_ID FROM drivers d WHERE d.Approved = 1 ORDER BY d.Name”;
    $result = mysql_query($sql) or die(“Couldn’t execute query 24.”);
    while ($row = mysql_fetch_array($result))
    {
    extract($row);

    $sql2 = “SELECT dd.Driver_ID FROM driver_detail dd WHERE dd.Series_ID = $S_ID AND dd.App_Approved = 1 AND dd.Driver_ID = $Driver_ID”;
    $result2 = mysql_query($sql2) or die(“Couldn’t execute query 24.”);
    $num = mysql_num_rows($result2);

    if(empty($num))
    {
    echo “\n”;
    }

    }

    echo “\n”;
    echo “

    0)
    {

    if($Error==0)
    {
    $sql = “SELECT * FROM drivers d INNER JOIN driver_detail dd ON d.Driver_ID = dd.Driver_ID INNER JOIN series s ON s.Series_ID = dd.Series_ID WHERE d.Driver_ID = ‘$D_ID’ ORDER BY dd.Series_ID DESC LIMIT 1”;
    $result = mysql_query($sql)
    or die(“A MySQL error has occurred.
    Your Query: ” . $your_query . “
    AError: (” . mysql_errno() . “) ” . mysql_error());
    $row = mysql_fetch_array($result);
    extract($row);

    $pName = $Name;
    $piCust = $iCust_ID;
    $pEmail = $Email;
    $pSponsor = $Sponsor;
    $pTeam = $Team;
    $pNickname = $Nickname;
    $pBday = $DOB;
    $pHometown = $Hometown;
    }
    }

    ?>

    \n”;
    echo “

    \n”;
    ?>

    \n”;
    echo “

    \n”;
    ?>

    \n”;
    echo “

    \n”;
    ?>

    Email*
    00\n”;
    }

    ### Determine if 01 is taken
    $sql = “SELECT dd.Number as Taken FROM driver_detail dd INNER JOIN drivers d ON d.Driver_ID = dd.Driver_ID WHERE d.Approved = 1 AND dd.Series_ID = $S_ID AND Number=’9901′”;
    $result = mysql_query($sql)
    or die(“Couldn’t execute query 24.”);
    $num = mysql_num_rows($result);

    if ($Error == 1)
    {

    $Selected = ”;

    if($pFirst == ‘9901’)
    {
    $Selected = ‘Selected’;
    }
    }

    if ($num == 0)
    {
    echo “\n”;
    }

    ### Determine if 02 is taken
    $sql = “SELECT dd.Number as Taken FROM driver_detail dd INNER JOIN drivers d ON d.Driver_ID = dd.Driver_ID WHERE d.Approved = 1 AND dd.Series_ID = $S_ID AND Number=’9902′”;
    $result = mysql_query($sql)
    or die(“Couldn’t execute query 24.”);
    $num = mysql_num_rows($result);

    if ($Error == 1)
    {

    $Selected = ”;

    if($pFirst == ‘9902’)
    {
    $Selected = ‘Selected’;
    }
    }

    if ($num == 0)
    {
    echo “\n”;
    }

    ### Determine if 03 is taken
    $sql = “SELECT dd.Number as Taken FROM driver_detail dd INNER JOIN drivers d ON d.Driver_ID = dd.Driver_ID WHERE d.Approved = 1 AND dd.Series_ID = $S_ID AND Number=’9903′”;
    $result = mysql_query($sql)
    or die(“Couldn’t execute query 24.”);
    $num = mysql_num_rows($result);

    if ($Error == 1)
    {

    $Selected = ”;

    if($pFirst == ‘9903’)
    {
    $Selected = ‘Selected’;
    }
    }

    if ($num == 0)
    {
    echo “\n”;
    }

    ### Determine if 04 is taken
    $sql = “SELECT dd.Number as Taken FROM driver_detail dd INNER JOIN drivers d ON d.Driver_ID = dd.Driver_ID WHERE d.Approved = 1 AND dd.Series_ID = $S_ID AND Number=’9904′”;
    $result = mysql_query($sql)
    or die(“Couldn’t execute query 24.”);
    $num = mysql_num_rows($result);

    if ($Error == 1)
    {

    $Selected = ”;

    if($pFirst == ‘9904’)
    {
    $Selected = ‘Selected’;
    }
    }

    if ($num == 0)
    {
    echo “\n”;
    }

    ### Determine if 05 is taken
    $sql = “SELECT dd.Number as Taken FROM driver_detail dd INNER JOIN drivers d ON d.Driver_ID = dd.Driver_ID WHERE d.Approved = 1 AND dd.Series_ID = $S_ID AND Number=’9905′”;
    $result = mysql_query($sql)
    or die(“Couldn’t execute query 24.”);
    $num = mysql_num_rows($result);

    if ($Error == 1)
    {

    $Selected = ”;

    if($pFirst == ‘9905’)
    {
    $Selected = ‘Selected’;
    }
    }

    if ($num == 0)
    {
    echo “\n”;
    }

    ### Determine if 06 is taken
    $sql = “SELECT dd.Number as Taken FROM driver_detail dd INNER JOIN drivers d ON d.Driver_ID = dd.Driver_ID WHERE d.Approved = 1 AND dd.Series_ID = $S_ID AND Number=’9906′”;
    $result = mysql_query($sql)
    or die(“Couldn’t execute query 24.”);
    $num = mysql_num_rows($result);

    if ($Error == 1)
    {

    $Selected = ”;

    if($pFirst == ‘9906’)
    {
    $Selected = ‘Selected’;
    }
    }

    if ($num == 0)
    {
    echo “\n”;
    }

    ### Determine if 07 is taken
    $sql = “SELECT dd.Number as Taken FROM driver_detail dd INNER JOIN drivers d ON d.Driver_ID = dd.Driver_ID WHERE d.Approved = 1 AND dd.Series_ID = $S_ID AND Number=’9907′”;
    $result = mysql_query($sql)
    or die(“Couldn’t execute query 24.”);
    $num = mysql_num_rows($result);

    if ($Error == 1)
    {

    $Selected = ”;

    if($pFirst == ‘9907’)
    {
    $Selected = ‘Selected’;
    }
    }

    if ($num == 0)
    {
    echo “\n”;
    }

    ### Determine if 08 is taken
    $sql = “SELECT dd.Number as Taken FROM driver_detail dd INNER JOIN drivers d ON d.Driver_ID = dd.Driver_ID WHERE d.Approved = 1 AND dd.Series_ID = $S_ID AND Number=’9908′”;
    $result = mysql_query($sql)
    or die(“Couldn’t execute query 24.”);
    $num = mysql_num_rows($result);

    if ($Error == 1)
    {

    $Selected = ”;

    if($pFirst == ‘9908’)
    {
    $Selected = ‘Selected’;
    }
    }

    if ($num == 0)
    {
    echo “\n”;
    }

    ### Determine if 09 is taken
    $sql = “SELECT dd.Number as Taken FROM driver_detail dd INNER JOIN drivers d ON d.Driver_ID = dd.Driver_ID WHERE d.Approved = 1 AND dd.Series_ID = $S_ID AND Number=’9909′”;
    $result = mysql_query($sql)
    or die(“Couldn’t execute query 24.”);
    $num = mysql_num_rows($result);

    if ($Error == 1)
    {

    $Selected = ”;

    if($pFirst == ‘9909’)
    {
    $Selected = ‘Selected’;
    }
    }

    if ($num == 0)
    {
    echo “\n”;
    }

    ### Determine if 0-999 are taken
    for ($x = 0; $x <= 999; $x++) { $sql = "SELECT dd.Number as Taken FROM driver_detail dd INNER JOIN drivers d ON d.Driver_ID = dd.Driver_ID WHERE d.Approved = 1 AND dd.Series_ID = $S_ID AND Number=$x"; $result = mysql_query($sql) or die("Couldn't execute query 139."); $num = mysql_num_rows($result); if ($Error == 1) { $Selected = ''; if($pFirst == $x) { $Selected = 'Selected'; } } if ($num == 0) { echo "\n”;
    }
    }

    echo “\n”;
    echo “
    00\n”;
    }

    ### Determine if 01 is taken
    $sql = “SELECT dd.Number as Taken FROM driver_detail dd INNER JOIN drivers d ON d.Driver_ID = dd.Driver_ID WHERE d.Approved = 1 AND dd.Series_ID = $S_ID AND Number=’9901′”;
    $result = mysql_query($sql)
    or die(“Couldn’t execute query 24.”);
    $num = mysql_num_rows($result);

    if ($Error == 1)
    {

    $Selected = ”;

    if($pSecond == ‘9901’)
    {
    $Selected = ‘Selected’;
    }
    }

    if ($num == 0)
    {
    echo “\n”;
    }

    ### Determine if 02 is taken
    $sql = “SELECT dd.Number as Taken FROM driver_detail dd INNER JOIN drivers d ON d.Driver_ID = dd.Driver_ID WHERE d.Approved = 1 AND dd.Series_ID = $S_ID AND Number=’9902′”;
    $result = mysql_query($sql)
    or die(“Couldn’t execute query 24.”);
    $num = mysql_num_rows($result);

    if ($Error == 1)
    {

    $Selected = ”;

    if($pSecond == ‘9902’)
    {
    $Selected = ‘Selected’;
    }
    }

    if ($num == 0)
    {
    echo “\n”;
    }

    ### Determine if 03 is taken
    $sql = “SELECT dd.Number as Taken FROM driver_detail dd INNER JOIN drivers d ON d.Driver_ID = dd.Driver_ID WHERE d.Approved = 1 AND dd.Series_ID = $S_ID AND Number=’9903′”;
    $result = mysql_query($sql)
    or die(“Couldn’t execute query 24.”);
    $num = mysql_num_rows($result);

    if ($Error == 1)
    {

    $Selected = ”;

    if($pSecond == ‘9903’)
    {
    $Selected = ‘Selected’;
    }
    }

    if ($num == 0)
    {
    echo “\n”;
    }

    ### Determine if 04 is taken
    $sql = “SELECT dd.Number as Taken FROM driver_detail dd INNER JOIN drivers d ON d.Driver_ID = dd.Driver_ID WHERE d.Approved = 1 AND dd.Series_ID = $S_ID AND Number=’9904′”;
    $result = mysql_query($sql)
    or die(“Couldn’t execute query 24.”);
    $num = mysql_num_rows($result);

    if ($Error == 1)
    {

    $Selected = ”;

    if($pSecond == ‘9904’)
    {
    $Selected = ‘Selected’;
    }
    }

    if ($num == 0)
    {
    echo “\n”;
    }

    ### Determine if 05 is taken
    $sql = “SELECT dd.Number as Taken FROM driver_detail dd INNER JOIN drivers d ON d.Driver_ID = dd.Driver_ID WHERE d.Approved = 1 AND dd.Series_ID = $S_ID AND Number=’9905′”;
    $result = mysql_query($sql)
    or die(“Couldn’t execute query 24.”);
    $num = mysql_num_rows($result);

    if ($Error == 1)
    {

    $Selected = ”;

    if($pSecond == ‘9905’)
    {
    $Selected = ‘Selected’;
    }
    }

    if ($num == 0)
    {
    echo “\n”;
    }

    ### Determine if 06 is taken
    $sql = “SELECT dd.Number as Taken FROM driver_detail dd INNER JOIN drivers d ON d.Driver_ID = dd.Driver_ID WHERE d.Approved = 1 AND dd.Series_ID = $S_ID AND Number=’9906′”;
    $result = mysql_query($sql)
    or die(“Couldn’t execute query 24.”);
    $num = mysql_num_rows($result);

    if ($Error == 1)
    {

    $Selected = ”;

    if($pSecond == ‘9906’)
    {
    $Selected = ‘Selected’;
    }
    }

    if ($num == 0)
    {
    echo “\n”;
    }

    ### Determine if 07 is taken
    $sql = “SELECT dd.Number as Taken FROM driver_detail dd INNER JOIN drivers d ON d.Driver_ID = dd.Driver_ID WHERE d.Approved = 1 AND dd.Series_ID = $S_ID AND Number=’9907′”;
    $result = mysql_query($sql)
    or die(“Couldn’t execute query 24.”);
    $num = mysql_num_rows($result);

    if ($Error == 1)
    {

    $Selected = ”;

    if($pSecond == ‘9907’)
    {
    $Selected = ‘Selected’;
    }
    }

    if ($num == 0)
    {
    echo “\n”;
    }

    ### Determine if 08 is taken
    $sql = “SELECT dd.Number as Taken FROM driver_detail dd INNER JOIN drivers d ON d.Driver_ID = dd.Driver_ID WHERE d.Approved = 1 AND dd.Series_ID = $S_ID AND Number=’9908′”;
    $result = mysql_query($sql)
    or die(“Couldn’t execute query 24.”);
    $num = mysql_num_rows($result);

    if ($Error == 1)
    {

    $Selected = ”;

    if($pSecond == ‘9908’)
    {
    $Selected = ‘Selected’;
    }
    }

    if ($num == 0)
    {
    echo “\n”;
    }

    ### Determine if 09 is taken
    $sql = “SELECT dd.Number as Taken FROM driver_detail dd INNER JOIN drivers d ON d.Driver_ID = dd.Driver_ID WHERE d.Approved = 1 AND dd.Series_ID = $S_ID AND Number=’9909′”;
    $result = mysql_query($sql)
    or die(“Couldn’t execute query 24.”);
    $num = mysql_num_rows($result);

    if ($Error == 1)
    {

    $Selected = ”;

    if($pSecond == ‘9909’)
    {
    $Selected = ‘Selected’;
    }
    }

    if ($num == 0)
    {
    echo “\n”;
    }

    ### Determine if 0-999 are taken
    for ($x = 0; $x <= 999; $x++) { $sql = "SELECT dd.Number as Taken FROM driver_detail dd INNER JOIN drivers d ON d.Driver_ID = dd.Driver_ID WHERE d.Approved = 1 AND dd.Series_ID = $S_ID AND Number=$x"; $result = mysql_query($sql) or die("Couldn't execute query 139."); $num = mysql_num_rows($result); if ($Error == 1) { $Selected = ''; if($pSecond == $x) { $Selected = 'Selected'; } } if ($num == 0) { echo "\n”;
    }
    } echo “\n”;
    echo “
    00\n”;
    }

    ### Determine if 01 is taken
    $sql = “SELECT dd.Number as Taken FROM driver_detail dd INNER JOIN drivers d ON d.Driver_ID = dd.Driver_ID WHERE d.Approved = 1 AND dd.Series_ID = $S_ID AND Number=’9901′”;
    $result = mysql_query($sql)
    or die(“Couldn’t execute query 24.”);
    $num = mysql_num_rows($result);

    if ($Error == 1)
    {

    $Selected = ”;

    if($pThird == ‘9901’)
    {
    $Selected = ‘Selected’;
    }
    }

    if ($num == 0)
    {
    echo “\n”;
    }

    ### Determine if 02 is taken
    $sql = “SELECT dd.Number as Taken FROM driver_detail dd INNER JOIN drivers d ON d.Driver_ID = dd.Driver_ID WHERE d.Approved = 1 AND dd.Series_ID = $S_ID AND Number=’9902′”;
    $result = mysql_query($sql)
    or die(“Couldn’t execute query 24.”);
    $num = mysql_num_rows($result);

    if ($Error == 1)
    {

    $Selected = ”;

    if($pThird == ‘9902’)
    {
    $Selected = ‘Selected’;
    }
    }

    if ($num == 0)
    {
    echo “\n”;
    }

    ### Determine if 03 is taken
    $sql = “SELECT dd.Number as Taken FROM driver_detail dd INNER JOIN drivers d ON d.Driver_ID = dd.Driver_ID WHERE d.Approved = 1 AND dd.Series_ID = $S_ID AND Number=’9903′”;
    $result = mysql_query($sql)
    or die(“Couldn’t execute query 24.”);
    $num = mysql_num_rows($result);

    if ($Error == 1)
    {

    $Selected = ”;

    if($pThird == ‘9903’)
    {
    $Selected = ‘Selected’;
    }
    }

    if ($num == 0)
    {
    echo “\n”;
    }

    ### Determine if 04 is taken
    $sql = “SELECT dd.Number as Taken FROM driver_detail dd INNER JOIN drivers d ON d.Driver_ID = dd.Driver_ID WHERE d.Approved = 1 AND dd.Series_ID = $S_ID AND Number=’9904′”;
    $result = mysql_query($sql)
    or die(“Couldn’t execute query 24.”);
    $num = mysql_num_rows($result);

    if ($Error == 1)
    {

    $Selected = ”;

    if($pThird == ‘9904’)
    {
    $Selected = ‘Selected’;
    }
    }

    if ($num == 0)
    {
    echo “\n”;
    }

    ### Determine if 05 is taken
    $sql = “SELECT dd.Number as Taken FROM driver_detail dd INNER JOIN drivers d ON d.Driver_ID = dd.Driver_ID WHERE d.Approved = 1 AND dd.Series_ID = $S_ID AND Number=’9905′”;
    $result = mysql_query($sql)
    or die(“Couldn’t execute query 24.”);
    $num = mysql_num_rows($result);

    if ($Error == 1)
    {

    $Selected = ”;

    if($pThird == ‘9905’)
    {
    $Selected = ‘Selected’;
    }
    }

    if ($num == 0)
    {
    echo “\n”;
    }

    ### Determine if 06 is taken
    $sql = “SELECT dd.Number as Taken FROM driver_detail dd INNER JOIN drivers d ON d.Driver_ID = dd.Driver_ID WHERE d.Approved = 1 AND dd.Series_ID = $S_ID AND Number=’9906′”;
    $result = mysql_query($sql)
    or die(“Couldn’t execute query 24.”);
    $num = mysql_num_rows($result);

    if ($Error == 1)
    {

    $Selected = ”;

    if($pThird == ‘9906’)
    {
    $Selected = ‘Selected’;
    }
    }

    if ($num == 0)
    {
    echo “\n”;
    }

    ### Determine if 07 is taken
    $sql = “SELECT dd.Number as Taken FROM driver_detail dd INNER JOIN drivers d ON d.Driver_ID = dd.Driver_ID WHERE d.Approved = 1 AND dd.Series_ID = $S_ID AND Number=’9907′”;
    $result = mysql_query($sql)
    or die(“Couldn’t execute query 24.”);
    $num = mysql_num_rows($result);

    if ($Error == 1)
    {

    $Selected = ”;

    if($pThird == ‘9907’)
    {
    $Selected = ‘Selected’;
    }
    }

    if ($num == 0)
    {
    echo “\n”;
    }

    ### Determine if 08 is taken
    $sql = “SELECT dd.Number as Taken FROM driver_detail dd INNER JOIN drivers d ON d.Driver_ID = dd.Driver_ID WHERE d.Approved = 1 AND dd.Series_ID = $S_ID AND Number=’9908′”;
    $result = mysql_query($sql)
    or die(“Couldn’t execute query 24.”);
    $num = mysql_num_rows($result);

    if ($Error == 1)
    {

    $Selected = ”;

    if($pThird == ‘9908’)
    {
    $Selected = ‘Selected’;
    }
    }

    if ($num == 0)
    {
    echo “\n”;
    }

    ### Determine if 09 is taken
    $sql = “SELECT dd.Number as Taken FROM driver_detail dd INNER JOIN drivers d ON d.Driver_ID = dd.Driver_ID WHERE d.Approved = 1 AND dd.Series_ID = $S_ID AND Number=’9909′”;
    $result = mysql_query($sql)
    or die(“Couldn’t execute query 24.”);
    $num = mysql_num_rows($result);

    if ($Error == 1)
    {

    $Selected = ”;

    if($pThird == ‘9909’)
    {
    $Selected = ‘Selected’;
    }
    }

    if ($num == 0)
    {
    echo “\n”;
    }

    ### Determine if 0-999 are taken
    for ($x = 0; $x <= 999; $x++) { $sql = "SELECT dd.Number as Taken FROM driver_detail dd INNER JOIN drivers d ON d.Driver_ID = dd.Driver_ID WHERE d.Approved = 1 AND dd.Series_ID = $S_ID AND Number=$x"; $result = mysql_query($sql) or die("Couldn't execute query 139."); $num = mysql_num_rows($result); if ($Error == 1) { $Selected = ''; if($pThird == $x) { $Selected = 'Selected'; } } if ($num == 0) { echo "\n”;
    }
    }

    echo “\n”;
    echo “