PHP-Code:
<form method="POST" name="addreports" action="<?php echo $_SERVER["PHP_SELF"]; ?>">
<table width="100%" border="1" cellspacing="0" cellpadding="0" bordercolor="#CCCCCC">
<tr>
<td colspan="2" bgcolor="#999999"><strong><div class="fieldborder"><?php echo $row["Vereine_name"] ?></div></strong></td>
<td width="2%" bgcolor="#999999"><div class="fieldborder"> </div></td>
<td colspan="2" bgcolor="#999999"><strong><div class="fieldborder"><?php echo $row["Vereine_Name"] ?></strong></div></td>
</tr>
<tr>
<td><div class="fieldborder"> </div></td>
<td><div class="fieldborder"> </div></td>
<td><div class="fieldborder"> </div></td>
<td><div class="fieldborder"> </div></td>
<td><div class="fieldborder"> </div></td>
</tr>
<tr>
<td align="right"><div class="fieldborder">Heimmannschaft Sets </div></td>
<td align="right"><div class="fieldborder"><input size="10" name="Fights_Set_Plus" value="" /></div></td>
<td align="center"><div class="fieldborder">:</div></td>
<td><div class="fieldborder"><input size="10" name="Fights_Set_Minus" value="" /></div></td>
<td><div class="fieldborder">Gastmannschaft Sets</div></td>
</tr>
<tr>
<td align="right">Heimmannschaft Legs </td>
<td align="right"><div class="fieldborder"><input size="10" name="Fights_Legs_Plus" value="" /></div></td>
<td align="center"><div class="fieldborder">:</div></td>
<td><div class="fieldborder"><input size="10" name="Fights_Legs_Minus" value="" /></div></td>
<td><div class="fieldborder">Gastmannschaft Legs</div></td>
</tr>
<tr>
<td align="right">Heim Punkte </td>
<td align="right"><div class="fieldborder"><input size="10" name="Heim_Punkte" value="" /></div></td>
<td align="center"><div class="fieldborder">:</div></td>
<td><div class="fieldborder"><input size="10" name="Gast_Punkte" value="" /></div></td>
<td><div class="fieldborder">Gast Punkte</div></td>
</tr>
<tr>
<td colspan="2"><div class="fieldborder">
<table width="100%" border="1" cellspacing="0" cellpadding="0" bordercolor="#CCCCCC">
<tr>
<td bgcolor="#999999"><strong><div class="fieldborder">Spieler</div></td>
<td bgcolor="#999999"><strong><div class="fieldborder">Punkte</div></td>
</tr>
<?php
$hid = $row["Fights_Home_Vereine_ID"] ;
$homequery = "Select * from Member where Member_Vereine_ID = $hid";
$rowhome = $db->fetchAll($homequery);
for($hi = 0; $hi<$db->numrows($homequery); $hi++){
?>
<tr>
<td><div class="fieldborder"><?php echo $rowhome[$hi]["Member_Name"] ?> <?php echo $rowhome[$hi]["Member_Nachname"] ?></div></td>
<td><div class="fieldborder"><input size="10" name="Fight_Points_Point" value="0" /></div></td>
</tr>
<?php
}
?>
</table>
</div></td>
<td><div class="fieldborder"> </div></td>
<td colspan="2"><div class="fieldborder">
<table width="100%" border="1" cellspacing="0" cellpadding="0" bordercolor="#CCCCCC">
<tr>
<td bgcolor="#999999"><strong><div class="fieldborder">Spieler</div></td>
<td bgcolor="#999999"><strong><div class="fieldborder">Punkte</div></td>
</tr>
<?php
$gid = $row["Fights_Guest_Vereine_ID"] ;
$Guestquery = "Select * from Member where Member_Vereine_ID = $gid";
$rowguest = $db->fetchAll($Guestquery);
for($gi = 0; $gi<$db->numrows($Guestquery); $gi++){
?>
<tr>
<td><div class="fieldborder"><?php echo $rowguest[$gi]["Member_Name"] ?> <?php echo $rowguest[$gi]["Member_Nachname"] ?></div></td>
<td><div class="fieldborder"><input size="10" name="Fight_Points_Point" value="0" /></div></td>
</tr>
<?php
}
?>
</table>
</div></td>
</tr>
<tr>
<td><div class="fieldborder"><input type="hidden" name="Home_Vereine_ID" value="<?php echo $row["Fights_Home_Vereine_ID"] ?>"></div></td>
<td><div class="fieldborder"><input type="hidden" name="Guest_Vereine_ID" value="<?php echo $row["Fights_Guest_Vereine_ID"] ?>"></div></td>
<td><div class="fieldborder"> </div></td>
<td><div class="fieldborder"> </div></td>
<td><div class="fieldborder"> </div></td>
</tr>
<tr>
<td><div class="fieldborder"><input type="hidden" name="addreports" value="true"></div></td>
<td><div class="fieldborder"><input type="hidden" name="reportid" value="<?php echo $row["Fights_ID"] ?>"></div></td>
<td><div class="fieldborder"><input type="hidden" name="did" value="<?php echo $did ?>"></div></td>
<td><div class="fieldborder"> </div></td>
<td><div class="fieldborder"><input type="SUBMIT" value="Hinzufügen"></div></td>
</tr>
</table>
</form>
Die Spieler werde auch aus der DB geholt. Und es wäre relative egal ob ich die Daten auf einmal in die Datenbank schreibe oder auf 2 Steps (mit der Variante teste gerade) ^^
LG Rene