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);
?>