help needed looping a form

[chris_s_22]

this is my site http://www.pinkangel4u.com/truthdare/
you can login with ussername = "chris" password = "smith"
ive created a table in my database called "game"
the feilds are id, gameno, name, sex, score, finalscore
the form code can be viewed here http://pastebin.com/m21d43d73
that form then asks for creategame.php
code is here http://pastebin.com/m64deb482

this is my function.php page http://pastebin.com/m6b863ba8

what im stuggling is how i can have the data in the table
so i think what i am asking is how do i loop so each player is entered
so effectively for each gameno there will be 15 enteries

id autoincrement
gameno this will have to be the same for each player within the form
name what is entered in namebox 1
sex what is entered in sexbox 1
score default 0
final score what is entered in the bottom of form

this will then be repeated for each player entered

also each form submitted to have a different gameno

also

[bretticus]

Because you stuck brackets [] at the end of your input names you only need to treat the corresponding $_POST variables as arrays and loop through them:

<?php
foreach($_POST['playername'] as $playername) {
     create_game ($playername, $_POST['sex'], $_POST['finalscore']);
}
?>

This works great if you only want to submit the names of the players. However, you have no way of knowing which sex is attributed to which name using this method.

Assuming that the inputs will be sent in the same order as they display on the page, you might get away with using a for loop and an increment variable:

for($i = 0; $i < count($_POST['playername']); $i++) {
     create_game ($_POST['playername'][$i], $_POST['sex'][$i], "no idea!");
}

I'd test that thoroughly before committing to use it!

Another way is to use a unique index for each input name to bind corresponding inputs together:

<form action="creategame.php" method="post"> 
<input type="text" name="player[0][name]" value="Player 1" size='35'><select name="player[0][sex]"><option>Male</option><option>Female</option></select><br> 
<input type="text" name="player[1][name]" value="Player 2" size='35'><select name="player[1][sex]"><option>Male</option><option>Female</option></select><br>
<!--continue...-->

Then it should be as simple as:

<?php
foreach($_POST['player'] as $player) {
     create_game ($player['name'], $player['sex'], '...still no idea...');
}
?>