Update multiple Rows

netman182

I have a form which sends the teamid to the form. that works. Now i am having a problem updating fields from that point. I will be updating some records and others i wont need to update. i am having a problem with the update SQL statement. if anyone can help that would be great.

i have tried 2 different sql statements. i have added ' single qoutes but no change.

here is my code:

<?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);
?>
<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");
}
?>

halojoy

So what mysql_error() do you get?
It is good sometimes to get this information after a query.
http://php.net/manual/en/function.mysql-error.php

In your script I would put an error test at this point

<?php

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);
// test for mysql_error here
// if( mysql_error()) echo mysql_error();

}

?>

netman182

that is the thing i get no error.

halojoy

What is value of $count
if you put in one echo $count;

<?php
// Count table rows 
$count=mysql_num_rows($result);
echo 'count='.$count;
?>

halojoy

You can try put indexed variables inside curly braces {}
like this:

$sql1="UPDATE `players` SET `gp`='{$gp[$i]}', `goal`='{$goal[$i]}', `assist`='$assist[$i]',

toxic_brain

r u sure it reached inside the last if? check by putting an die.

if($Submit){
die('reached') ;
for($i=0;$i<$count;$i++){
. . .

if not, try changing

if($Submit)

if(isset($_POST['Submit'])

lastly, don't foget to use PHP tags while you post html/php code to the thread