Advertisement
Guest User

Untitled

a guest
Apr 24th, 2014
40
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.69 KB | None | 0 0
  1. while ($row = mysql_fetch_assoc($result))
  2. {
  3.  
  4. $reID = $row['reID'];
  5. $racerID = $row['racerID'];
  6.  
  7. echo "<tr>";
  8. echo "<td>$reID<input type='hidden' name='reID' value='$reID'>";
  9. echo "<td>$racerID<input type='hidden' name='racerID' value='$racerID'>";
  10.  
  11. echo"<td><input type='text' name='rank'>";
  12. echo"<td><input type='text' name='timetaken'>";
  13.  
  14. }
  15.  
  16. $count = 0;
  17. while ($row = mysql_fetch_assoc($result))
  18. {
  19. $count++;
  20.  
  21. $reID = $row['reID'];
  22. $racerID = $row['racerID'];
  23.  
  24. echo "<tr>";
  25. echo "<td>$reID<input type='hidden' name='reID$count' value='$reID'>";
  26. echo "<td>$racerID<input type='hidden' name='racerID$count' value='$racerID'>";
  27.  
  28. echo"<td><input type='text' name='rank$count'>";
  29. echo"<td><input type='text' name='timetaken$count'>";
  30.  
  31. }
  32. echo "<input type='hidden' name='count' value='$count' />";
  33.  
  34. $rank=$_POST['rank'];
  35. $timetaken=$_POST['timetaken'];
  36. $reID=$_POST['reID'];
  37. $racerID=$_POST['racerID'];
  38. $count_racerID= count($_POST['racerID']);
  39.  
  40. $count = $_POST['count'];
  41. for($i=1; $i<=$count; $i++){
  42. $rank[] = $_POST['rank'.$i];
  43. $timetaken[] = $_POST['timetaken'.$i];
  44. $reID[] = $_POST['reID'.$i];
  45. $racerID[] = $_POST['racerID'.$i];
  46. }
  47. $count_racerID = $count;
  48.  
  49. $sql = mysql_query("INSERT INTO RaceResults (rank, timetaken, reID, racerID) VALUES ('$rank', '$timetaken', '$reID', '$racerID')");
  50.  
  51. $sql = mysql_query("INSERT INTO RaceResults (rank, timetaken, reID, racerID) VALUES ('$_rank', '$_timetaken', '$_reID', '$_racerID')");
  52.  
  53. $reID = $_GET['reID'];
  54. $result = mysql_query("SELECT * FROM RaceEventRacer WHERE reID = $reID");
  55.  
  56. $count = 0;
  57. while ($row = mysql_fetch_assoc($result))
  58. {
  59. $count++;
  60.  
  61. $reID = $row['reID'];
  62. $racerID = $row['racerID'];
  63.  
  64. echo "<tr>";
  65. echo "<td>$reID<input type='hidden' name='reID$count' value='$reID'>";
  66. echo "<td>$racerID<input type='hidden' name='racerID$count' value='$racerID'>";
  67.  
  68. echo"<td><input type='text' name='rank$count'>";
  69. echo"<td><input type='text' name='timetaken$count'>";
  70.  
  71. }
  72. echo "<input type='hidden' name='count' value='$count' />";
  73.  
  74. $count = $_POST['count'];
  75. for($i=1; $i<=$count; $i++){
  76. $rank[] = $_POST['rank'.$i];
  77. $timetaken[] = $_POST['timetaken'.$i];
  78. $reID[] = $_POST['reID'.$i];
  79. $racerID[] = $_POST['racerID'.$i];
  80. }
  81. $count_racerID = $count;
  82.  
  83. for($i=0;$i<$count_racerID;$i++){
  84. $_rank= mysql_escape_string($rank[$i]);
  85. $_timetaken= mysql_escape_string($timetaken[$i]);
  86. $_reID= mysql_escape_string($reID[$i]);
  87. $_racerID= mysql_escape_string($racerID[$i]);
  88.  
  89. $sql = mysql_query("INSERT INTO RaceResults (rank, timetaken, reID, racerID) VALUES ('$_rank', '$_timetaken', '$_reID', '$_racerID')");
  90. $result = mysql_query($sql);
  91. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement