Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- while ($row = mysql_fetch_assoc($result))
- {
- $reID = $row['reID'];
- $racerID = $row['racerID'];
- echo "<tr>";
- echo "<td>$reID<input type='hidden' name='reID' value='$reID'>";
- echo "<td>$racerID<input type='hidden' name='racerID' value='$racerID'>";
- echo"<td><input type='text' name='rank'>";
- echo"<td><input type='text' name='timetaken'>";
- }
- $count = 0;
- while ($row = mysql_fetch_assoc($result))
- {
- $count++;
- $reID = $row['reID'];
- $racerID = $row['racerID'];
- echo "<tr>";
- echo "<td>$reID<input type='hidden' name='reID$count' value='$reID'>";
- echo "<td>$racerID<input type='hidden' name='racerID$count' value='$racerID'>";
- echo"<td><input type='text' name='rank$count'>";
- echo"<td><input type='text' name='timetaken$count'>";
- }
- echo "<input type='hidden' name='count' value='$count' />";
- $rank=$_POST['rank'];
- $timetaken=$_POST['timetaken'];
- $reID=$_POST['reID'];
- $racerID=$_POST['racerID'];
- $count_racerID= count($_POST['racerID']);
- $count = $_POST['count'];
- for($i=1; $i<=$count; $i++){
- $rank[] = $_POST['rank'.$i];
- $timetaken[] = $_POST['timetaken'.$i];
- $reID[] = $_POST['reID'.$i];
- $racerID[] = $_POST['racerID'.$i];
- }
- $count_racerID = $count;
- $sql = mysql_query("INSERT INTO RaceResults (rank, timetaken, reID, racerID) VALUES ('$rank', '$timetaken', '$reID', '$racerID')");
- $sql = mysql_query("INSERT INTO RaceResults (rank, timetaken, reID, racerID) VALUES ('$_rank', '$_timetaken', '$_reID', '$_racerID')");
- $reID = $_GET['reID'];
- $result = mysql_query("SELECT * FROM RaceEventRacer WHERE reID = $reID");
- $count = 0;
- while ($row = mysql_fetch_assoc($result))
- {
- $count++;
- $reID = $row['reID'];
- $racerID = $row['racerID'];
- echo "<tr>";
- echo "<td>$reID<input type='hidden' name='reID$count' value='$reID'>";
- echo "<td>$racerID<input type='hidden' name='racerID$count' value='$racerID'>";
- echo"<td><input type='text' name='rank$count'>";
- echo"<td><input type='text' name='timetaken$count'>";
- }
- echo "<input type='hidden' name='count' value='$count' />";
- $count = $_POST['count'];
- for($i=1; $i<=$count; $i++){
- $rank[] = $_POST['rank'.$i];
- $timetaken[] = $_POST['timetaken'.$i];
- $reID[] = $_POST['reID'.$i];
- $racerID[] = $_POST['racerID'.$i];
- }
- $count_racerID = $count;
- for($i=0;$i<$count_racerID;$i++){
- $_rank= mysql_escape_string($rank[$i]);
- $_timetaken= mysql_escape_string($timetaken[$i]);
- $_reID= mysql_escape_string($reID[$i]);
- $_racerID= mysql_escape_string($racerID[$i]);
- $sql = mysql_query("INSERT INTO RaceResults (rank, timetaken, reID, racerID) VALUES ('$_rank', '$_timetaken', '$_reID', '$_racerID')");
- $result = mysql_query($sql);
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement