Hey there i have some code i need to update multiple records at one time. can i get some help.
i have a page that selects what team i want to edit the stats for. then it sends it to another page where i can make changes to the stats. I can't figure this out at all. why is it not updating the players DB. i have another page where it is just changed approved field and that works fine but this is not. am i not doing something right. i will include the drop-down list page and the stats edit page as well as the page where i am just changing the approved field.
here is the link to the live pages so you can see how it works: http://bccsl.org/bccsltest/login/drop2.php
thanks in advance.
stefan
drop.php
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>
<body>
<form id="teamsearch" name="teamsearch" method="post" action="update_multiple.php">
<p> </p>
<p>
<label>
<?php
include 'dbc.php';
$query="SELECT teamname,teamid FROM teams";
/* You can add order by clause to the sql statement if the names are to be displayed in alphabetical order */
$result = mysql_query ($query);
echo "<select name=teamid value='$nt[teamid]'>Team Name</option>";
// printing the list box select command
while($nt=mysql_fetch_array($result)){//Array or records stored in $nt
echo "<option value='$nt[teamid]'>$nt[teamname]</option>";
/* Option values are added by looping through the array */
}
echo "</select>";// Closing of list box
?>
<input name="submit" type="submit" id="submit" value="Submit" />
</form>
<p> </p>
<p> </p>
</body>
</html>update_multiple.php
<?php
include 'dbc.php';
$tbl_name="players"; // Table name
// Connect to server and select databse.
$sql="select * from players where teamid='$_POST[teamid]'";
$result=mysql_query($sql);
// Count table rows
// $count=mysql_num_rows($result);
// Count table rows
$count=mysql_num_rows($result);
echo 'count='.$count;
?>
<table width="500" border="0" cellspacing="1" cellpadding="0">
<form name="form1" method="post" action="">
<tr>
<td>
<table width="500" border="0" cellspacing="1" cellpadding="0">
<tr>
<td align="center"><strong>Id</strong></td>
<td align="center"><strong>First Name</strong></td>
<td align="center"><strong>Last name</strong></td>
<td align="center"><strong>Team ID</strong></td>
<td align="center"><strong>Games Played</strong></td>
<td align="center"><strong>Goals</strong></td>
<td align="center"><strong>Assists</strong></td>
<td align="center"><strong>Points</strong></td>
<td align="center" bgcolor="#FFFF00"><strong>Yellow Cards</strong></td>
<td align="center" bgcolor="#FF0000"><strong>Red Cards</strong></td>
<td align="center"><strong>Suspension</strong></td>
</tr>
<?php
while($rows=mysql_fetch_array($result)){
?>
<tr>
<td align="center"><? $id[]=$rows['ID']; ?><? echo $rows['ID']; ?></td>
<td align="center"><input name="first[]" type="text" id="first" size="15" value="<? echo $rows['first']; ?>" disabled="disabled"></td>
<td align="center"><input name="last[]" type="text" id="last" size="15" value="<? echo $rows['last']; ?>" disabled="disabled"></td>
<td align="center"><input name="teamid[]" type="text" id="teamid" size="15" value="<? echo $rows['teamid']; ?>" disabled="disabled"></td>
<td align="center"><input name="gp[]" type="text" id="gp" size="10" value="<? echo $rows['gp']; ?>"></td>
<td align="center"><input name="goal[]" type="text" id="goal" size="10" value="<? echo $rows['goal']; ?>"></td>
<td align="center"><input name="assist[]" type="text" id="assist" size="10" value="<? echo $rows['assist']; ?>"></td>
<td align="center"><input name="point[]" type="text" id="point" size="10" value="<? echo $rows['point']; ?>"></td>
<td align="center"><input name="yellow[]" type="text" id="yellow" size="10" value="<? echo $rows['yellow']; ?>"></td>
<td align="center"><input name="red[]" type="text" id="red" size="10" value="<? echo $rows['red']; ?>"></td>
<td align="center"><input name="susp[]" type="text" id="susp" size="10" value="<? echo $rows['susp']; ?>"></td>
</tr>
<?php
}
?>
<tr>
<td colspan="4" align="center"><input type="submit" name="Submit" value="Submit"></td>
</tr>
</table>
</td>
</tr>
</form>
</table>
<?php
// Check if button name "Submit" is active, do this
if($Submit){
for($i=0;$i<$count;$i++){
$sql1="UPDATE `players` SET `gp`='{$gp[$i]}', `goal`='{$goal[$i]}', `assist`='{$assist[$i]}', `point`='{$point[$i]}', `yellow`='{$yellow[$i]}', `red`='{$red[$i]}', `susp`='{$susp[$i]}' WHERE `ID`='$ID[$i]'";
$result1=mysql_query($sql1);
}
}
if($result1){
header("location:update_multiple.php");
}
?>Players Table:
TABLE `players` (
`ID` int(11) NOT NULL default '0',
`first` varchar(255) default NULL,
`last` varchar(255) default NULL,
`address` varchar(255) default NULL,
`city` varchar(255) default NULL,
`postal` varchar(255) default NULL,
`phone` varchar(255) default NULL,
`feet` varchar(255) default NULL,
`inch` varchar(255) default NULL,
`weight` varchar(255) default NULL,
`yyyy` varchar(255) default NULL,
`mm` varchar(255) default NULL,
`dd` varchar(255) default NULL,
`teamid` varchar(255) default NULL,
`status` varchar(255) default NULL,
`gp` varchar(255) default NULL,
`goal` varchar(255) default NULL,
`assist` varchar(255) default NULL,
`point` varchar(255) default NULL,
`yellow` varchar(255) default NULL,
`red` varchar(255) default NULL,
`susp` varchar(255) default NULL,
`approved` int(11) default '0',
PRIMARY KEY (`ID`)
