Hi guys, I have a problem with my UPDATE query. It doesn't generate any error messages, but it just won't update the fields.
I have pasted the document here, but all you need to do (I guess) is to take a look at the lower part, where I run my "$ugstats = "UPDATE stats...."
any help will be MOST GREATLY appreciated! this problems has been bugging me for 2 days now!
<?
$g2INFO = "SELECT player.Pos, stats.PlayerID, stats.TeamID, stats.KID, team.Team, stats.StartDate, stats.EndDate, stats.League, stats.GP, stats.G, stats.A, stats.TP, stats.PIM FROM player INNER JOIN team ON team.TeamID = stats.TeamID INNER JOIN stats ON player.PlayerID = stats.PlayerID WHERE stats.PlayerID LIKE '$PlayerID' ORDER BY stats.PlayerID, stats.StartDate";
$result7 = mysql_query($g2INFO,$db_link);
$rows = mysql_num_rows($result7);
if ( $Pos == "G")
{
?>
<table width="600" border="0" cellpadding="1" cellspacing=0>
<tr bgcolor="black">
<td align="left"><font color="white">StartDate</font></td>
<td align="left"><font color="white">EndDate</font></td>
<td align="left"><font color="white">Team</font></td>
<td align="left"><font color="white">League</font></td>
<td align="center"><font color="white">GP</font></td>
<td align="center"><font color="white">GAA</font></td>
<td align="center"><font color="white">SVS%</font></td>
</tr>
<FORM ACTION="addplayerstats.php?player=<? echo "$PlayerID"; ?>" METHOD="Post" id=form1 name=form1>
<?
for($index = 0; $index< $rows; $index++) {
$PlayerID = mysql_result($result7, $index, "PlayerID");
$TeamID = mysql_result($result7, $index, "TeamID");
$KID = mysql_result($result7, $index, "KID");
$Pos = mysql_result($result7, $index, "Pos");
$Team = mysql_result($result7, $index, "Team");
$StartDate = mysql_result($result7, $index, "StartDate");
$EndDate = mysql_result($result7, $index, "EndDate");
$League = mysql_result($result7, $index, "League");
$GP = mysql_result($result7, $index, "GP");
$G = mysql_result($result7, $index, "G");
$A = mysql_result($result7, $index, "A");
$itplayer = "SELECT TeamID, Team FROM team ORDER BY Team asc";
$result9 = mysql_query($itplayer,$db_link);
$rows2 = mysql_num_rows($result9);
?>
<tr bgcolor="white">
<td align="left" class="input"><INPUT TYPE="TEXT" SIZE="4" NAME="startdate" ID="startdate" value="<? echo "$StartDate";?>"></td>
<td align="left" class="input"><INPUT TYPE="TEXT" SIZE="4" NAME="enddate" ID="enddate" value="<? echo "$EndDate";?>"></td>
<td align="left" class="input"><SELECT NAME="team" ID="team">
<?
$tID = 0;
$tname ="";
for($index2 = 0; $index2 < $rows2; $index2++)
{
$tID = mysql_result($result9, $index2, "TeamID");
$tname = mysql_result($result9, $index2, "Team");
?>
<option value="<? echo "$tID"; ?>"
<?
if ($tID-0 == $TeamID){
echo "selected";
}?>>
<? echo "$tname";
}
?>
</OPTION>
</SELECT>
</TD>
<td align="left" class="input"><INPUT TYPE="TEXT" SIZE="10" NAME="league" ID="league" value="<? echo "$League";?>"></td>
<td align="right" class="input"><INPUT TYPE="TEXT" SIZE="2" NAME="gp" ID="gp" value="<? echo "$GP";?>"></td>
<td align="right" class="input"><INPUT TYPE="TEXT" SIZE="2" NAME="g" ID="g" value="<? echo "$G";?>"></td>
<td align="right" class="input"><INPUT TYPE="TEXT" SIZE="2" NAME="a" ID="a" value="<? echo "$A";?>"></td>
<td align="right" class="input"><INPUT SIZE="3" NAME="kidnr" type="hidden" ID="kidnr" value="<? echo "$KID";?>"></td>
</tr>
<?
}
?>
<TD class="input"><INPUT TYPE="SUBMIT" VALUE="Update Stats!" id=press6 name=press6></TD>
</FORM>
</TR>
</TABLE>
<?
for($index = 1; $index <= $StartDate; $index++)
{
$team = $POST['team'];
$startdate = $POST['startdate'];
$enddate = $POST['enddate'];
$league = $POST['league'];
$gp = $POST['gp'];
$g = $POST['g'];
$a = $POST['a'];
$Kid = $POST['kidnr'];
$ugstats = "UPDATE stats SET TeamID = '$team', StartDate = '$startdate', EndDate = '$enddate', League = '$league', GP = '$gp', G = '$g', A = '$a' WHERE PlayerID = $PlayerID AND KID= $Kid";
$result5 = mysql_query($ugsats,$db_link);
}
}
else {
echo "not a goalie";
}
?>
<!--END OF GOALIE-->
