It won't update the database...can somebody please tell me what's wrong.....?
Update.php
<?
include("Connections/PFHL.php");
mysql_select_db($database, $PFHL) or die( "Unable to select database");
$query="SELECT * FROM standings WHERE standings.Conference = 'Eastern'";
$result=mysql_query($query, $PFHL);
$num=mysql_numrows($result);
mysql_close();
$i=0;
while ($i < $num) {
$Team=mysql_result($result,$i,"Team");
$Games=mysql_result($result,$i,"Games");
$Wins=mysql_result($result,$i,"Wins");
$Ties=mysql_result($result,$i,"Ties");
$Losses=mysql_result($result,$i,"Losses");
$Points=mysql_result($result,$i,"Points");
$Division=mysql_result($result,$i,"Division");
$Conference=mysql_result($result,$i,"Conference");
?>
<html>
<head></head>
<body>
<form action="updated.php" method="POST">
<table border="1" cellspacing="0" cellpadding="2">
<tr>
<td width="104">Team</td>
<td width="40">Games</td>
<td width="40">Wins</td>
<td width="40">Ties</td>
<td width="40">Losses</td>
<td width="40">Points</td>
<td width="104">Division</td>
<td width="104">Conference</td>
</tr>
<tr>
<input type="hidden" name="TeamID" value="<? echo "$TeamID"; ?>">
<td width="104"><? echo "$Team"; ?></td>
<td width="40"><input type="text" name="Games" value="<? echo "$Games"; ?>"></td>
<td width="40"><input type="text" name="Wins" value="<? echo "$Wins"; ?>"></td>
<td width="40"><input type="text" name="Ties" value="<? echo "$Ties"; ?>"></td>
<td width="40"><input type="text" name="Losses" value="<? echo "$Losses"; ?>"></td>
<td width="40"><input type="text" name="Points" value="<? echo "$Points"; ?>"></td>
<td width="104"><? echo "$Division"; ?></td>
<td width="104"><? echo "$Conference"; ?></td>
<td><input type="submit" value="Update"></td>
</tr>
</table>
</form>
</body>
</html>
<?
++$i;
}
?>
updated.php
<?php
include("Connections/PFHL.php");
$Games=$POST['Games'];
$Wins=$POST['Wins'];
$Ties=$POST['Ties'];
$Losses=$POST['Losses'];
$Points=$_POST['Points'];
$query="UPDATE standings WHERE standings.Conference='Eastern' SET Games='$Games' Wins='$Wins' Ties='$Ties' Losses='$Losses' Points='$Points'";
mysql_select_db($database, $PFHL) or die( "Unable to select database");
mysql_query($query, $PFHL);
echo "Record Updated";
mysql_close();
?>
Please?
