I've looked in my Database there is two result_id records but only one displays... does anyone know why?
<?php
$result3 = mysql_query ("SELECT * From results_data where comp_run_id = $comp_run_id and group_id = $group_id");
while($row3 = mysql_fetch_array($result3)) {
$team1_id = $row3["team1_id"];
$team2_id = $row3["team2_id"];
$result_id = $row3["result_id"];
?>
Home team:
<select size="1" name="<?php echo $team1_id; ?>">
<?php
$result3 = mysql_query ("SELECT * From results_comp_run_teams where comp_run_id = $comp_run_id");
while($row3 = mysql_fetch_array($result3))
{
$teamid = $row3["team_id"];
$result4 = mysql_query ("SELECT * from results_team where team_id = $teamid");
$row4 = mysql_fetch_array($result4);
?>
<option value="<?php echo $row4["team_id"]; ?>"><?php echo $row4["team_name"]; ?></option>
<?php
}
?>
</select>
</font>
<font face="Verdana" size="2"> vs Away team: </font>
<font face="Arial" size="2"><font face="Verdana">
<select size="1" name="<?php echo $team2_id; ?>">
<?php
$result3 = mysql_query ("SELECT * From results_comp_run_teams where comp_run_id = $comp_run_id");
while($row3 = mysql_fetch_array($result3))
{
$teamid = $row3["team_id"];
$result4 = mysql_query ("SELECT * from results_team where team_id = $teamid");
$row4 = mysql_fetch_array($result4);
?>
<option value="<?php echo $row4["team_id"]; ?>"><?php echo $row4["team_name"]; ?></option>
<?php
}
?>
</select>
<br>
<input type="checkbox" value="1" name="delete<?php echo $result_id; ?>"> Delete game? <font size="1" color="red">Warning this deletes all game information saved for this result.</font></font>
<br><br>
<p>
<?php
}
?>
