Arrays and Forms Help
Posted: Wed Aug 29, 2007 7:08 pm
I need help figuring out how to name input tags if I want to create and array with the information to so I can input the values into a table in a databse. I have a list of players that have a last name, first name, jersey number, and postion. I gave all the input tags that same name to start with.
This gives me the list of players I need. I need to know where to go from here to get my sql statements.
Code: Select all
<?php
echo "$school $team_opt<br>";
echo "$division<br>";
$i=0;
foreach ($free_agent_team as $free_agent_team) {
$sql="SELECT playeridnum FROM free_agents WHERE free_agent_ID='$free_agent_team'";
$mysql_result=mysql_query($sql);
while ($row=mysql_fetch_array($mysql_result)) {
$playeridnum=$row["playeridnum"];
}
$sql="SELECT lastname,firstname FROM registration WHERE playeridnum='$playeridnum'";
$mysql_result=mysql_query($sql);
while ($row=mysql_fetch_array($mysql_result)) {
$lastname=$row["lastname"];
$firstname=$row["firstname"];
}
echo "<tr class=\"style53\"><td>$free_agent_team<input type=hidden name=newteam[] value=$free_agent_team>
</td><td>$playeridnum<input type=hidden name=newteam[] value=$playeridnum></td><td>
<input type=hidden name=newteam[] value=$lastname>$lastname, $firstname
<input type=hidden name=newteam[] value=$firstname></td><td>
<div align=\"center\"><input name=\"newteam[]\" type=\"text\" size=\"2\" maxlength=\"2\" class=\"style53\">
</div></td><td>
<div align=\"center\"><select name=newteam[] class=\"style53\">
<option value=\"O\">Offense</option>
<option value=\"D\">Defense</option>
<option value=\"G\">Goalie</option>
</select></div></td><td><div align=\"center\"><input type=\"checkbox\" name=newteam[] value=\"1\"></div></td>
<td><div align=\"center\"><input type=\"checkbox\" name=newteam[] value=\"1\"></div></td>
</tr>";
$i++;
}
?>