I'm trying to put together a registration form for little league baseball. I'd like to have a form where the parents can enter their information and the information for up to 5 children. I need a separate record for each player instead to one record for each family.
So what I need is to have the parent's information and one player's information in each record. If the parent is registering only one player, I'd like to only have one record created and not have four additional blank records.
Here is a very basic start to my registration form. If anyone knows of a solution for this, I'd be very grateful!
<form id="form1" name="form1" method="POST" action="insert.php">
<input type="text" name="ParentName" id="ParentName" />
<input type="text" name="Child1" id="Child1" />
<select name="Child1League" id="Child1League">
<option value="1">Shetlan</option>
<option value="2">Farm</option>
<option value="3">Mustang</option>
<option value="4">Bronco</option>
</select>
<select name="Child2League" id="Child2League">
<option value="1">Shetlan</option>
<option value="2">Farm</option>
<option value="3">Mustang</option>
<option value="4">Bronco</option>
</select>
<input type="text" name="Child2" id="Child2" />
<input type="submit" name="Submit" id="Submit" value="Submit" />
</form>