Here is the code i have. I want to tale and enter the drivers name into two different tables. I don't seem to be able because of the if...else statement. It enters into one but not the other.
<body>
<?php
$db = @mysql_connect("216.89.24.247", "midway", "myron");
@mysql_select_db("midway",$db);
if ($submit) {
//here if no ID then adding else we're editing
if ($drivers_id) {
$sql = "UPDATE drivers SET drivers_number='$drivers_number', name='$name',team='$team',crew='$crew',sponsors='$sponsors',age='$age',years_racing='$years_racing',class='$class',chasis='$chasis', engine='$engine',address='$address', school='$school', grade='$grade', favorite_movie='$favorite_movie', favorite_food='$favorite_food', highlights1='$highlights1' , highlights2='$highlights2', highlights3='$highlights3', highlights4='$highlights4',image1='$image1',image2='$image2' WHERE drivers_id=$drivers_id";
} else {
$sql = "INSERT INTO drivers (drivers_number,name,team,crew,sponsors,age,years_racing,class,chasis, engine,address, school, grade, favorite_movie, favorite_food, highlights1, highlights2, highlights3, highlights4,image1,image2) VALUES ('$drivers_number','$name','$team','$crew','$sponsors','$age','$years_racing','$class','$chasis','$engine','$address','$school','$grade','$favorite_movie','$favorite_food','$highlights1','$highlights2','$highlights3','$highlights4','$image1','image2')";
}
//run SQL against the DB
$result = mysql_query($sql);
echo "record updated/edited!<p>";
echo "<a href=enter_drivers.php>Back</a>";
} elseif ($delete) {
// delete a record
$sql = "DELETE FROM drivers WHERE drivers_id=$drivers_id";
$result = mysql_query($sql);
echo "$sql Record deleted!<p>";
echo "<a href=enter_drivers.php>Back</a>";
} else {
// This part happens if we don't hit submit
if (!$drivers_number) {
//Print the list if there is not editing
$result = mysql_query("SELECT * FROM drivers",$db);
while ($myrow = mysql_fetch_array($result)) {
printf("<a href=\"%s?drivers_id=%s\">%s %s</a>\n", $PHP_SELF, $myrow["drivers_id"], $myrow["drivers_number"], $myrow["name"]);
printf("<a href=\"%s?drivers_id=%s&delete=yes\">(DELETE)</a><br>", $PHP_SELF, $myrow["drivers_id"]);
}
}
?>
<p>
<a href="<?php echo $PHP_SELF?>">ADD A RECORD</a>
<p>
<form method="post" action="<?php echo $PHP_SELF?>">
<?php
if ($id) {
//editing so select a record
$sql = "SELECT * FROM drivers WHERE drivers_id=$drivers_id";
$result = mysql_query($sql);
$myrow = mysql_fetch_array($result);
$id = $myrow["drivers_id"];
$drivers_number = $myrow["drivers_number"];
$name = $myrow["name"];
$team = $myrow["team"];
$crew = $myrow["crew"];
$sponsors = $myrow["sponsors"];
$age = $myrow["age"];
$years_racing = $myrow["years_racing"];
$class = $myrow["class"];
$chasis = $myrow["chasis"];
$engine = $myrow["engine"];
$address = $myrow["address"];
$school = $myrow["school"];
$grade = $myrow["grade"];
$favorite_movie = $myrow["favorite_movie"];
$favorite_food = $myrow["favorite_food"];
$highlights1 = $myrow["highlights1"];
$highlights2 = $myrow["highlights2"];
$highlights3 = $myrow["highlights3"];
$highlights4 = $myrow["highlights4"];
$image1 = $myrow["image1"];
$image2 = $myrow["image2"];
//print the id for editing
?>
<input type=hidden name="drivers_id" value="<?php echo $drivers_id ?>">
<?php
}
?>
Drivers Number:<input type="Text" name="drivers_number" value="<?php echo $drivers_number ?>"><br>
Name:<input type="Text" name="name" value="<?php echo $name ?>"><br>
Team:<input type="Text" name="team" value="<?php echo $team ?>"><br>
Crew:<input type="Text" name="crew" value="<?php echo $crew ?>"><br>
Sponsors:<input type="Text" name="sponsors" value="<?php echo $sponsors ?>"><br>
Age:<input type="Text" name="age" value="<?php echo $age ?>"><br>
Years Racing:<input type="Text" name="years_racing" value="<?php echo $years_racing ?>"><br>
Class:<input type="Text" name="class" value="<?php echo $class ?>"><br>
Chasis:<input type="Text" name="chasis" value="<?php echo $chasis ?>"><br>
Engine:<input type="Text" name="engine" value="<?php echo $engine ?>"><br>
Address:<input type="Text" name="address" value="<?php echo $address ?>"><br>
School:<input type="Text" name="school" value="<?php echo $school ?>"><br>
Grade:<input type="Text" name="grade" value="<?php echo $grade ?>"><br>
Favorite Movie:<input type="Text" name="favorite_movie" value="<?php echo $favorite_movie ?>"><br>
Favorite Food:<input type="Text" name="favorite_food" value="<?php echo $favorite_food ?>"><br>
Highlights 1:<input type="Text" name="highlights1" value="<?php echo $highlights1 ?>"><br>
Highlights 2:<input type="Text" name="highlights2" value="<?php echo $highlights2 ?>"><br>
Highlights 3:<input type="Text" name="highlights3" value="<?php echo $highlights3 ?>"><br>
Highlights 4:<input type="Text" name="highlights4" value="<?php echo $highlights4 ?>"><br><br>
<b>Note:</b> If no image is used please enter <b>blank1.gif</b> in Top Image or <b>blank2.gif</b> in Middle Image.<br>
Top Image(must be exact file name (image.jpg or image.gif)):<input type="Text" name="image1" value="<?php echo $image1 ?>"><br>
Middle Image(must be exact file name (image.jpg or image.gif)):<input type="Text" name="image2" value="<?php echo $image2 ?>"><br>
<input type="Submit" name="submit" value="Enter information">
</form>
<?php
}
?>
</body>
