Sign Up – Sprint Week – Upstate Racing League

ID;

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

$sql = “SELECT Series_Name as S_Name, Series_Year, Series_ID as S_ID FROM series WHERE Series_ID = $S_ID”;
$result = mysql_query($sql)
or die(“Couldn’t execute query 10.”);
$row = mysql_fetch_array($result);
extract($row);

$sql = “SELECT * FROM colors”;
$result = mysql_query($sql)
or die(“Couldn’t execute query 15.”);
$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);

}

$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 receive an invoice by email to pay your entry fee.

After your entry fee has been received you will appear on the event driver roster.

Thank for your interest and support of the Upstate Racing League!

\n”;
echo “

\n”;

Click here for event info!

Have you raced with us before? If your name is in this list please select it and click Next!

New to the Upstate Racing League? Please select New Driver and click Next!

\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”;
?>

iRacing Customer Number*

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 “