hi, i have a complicated problem.. when i printed result to screen it is showing like this Name1 < input > Name2 < input > Name3 < input > and then i am putting some values into each row Name1 50 Name2 80 Name3 45 when i submited this form values are updating, but each row value is equal last row's value. so ; Name1 45 Name2 45 Name3 45.. if i try puting any value in first or second input then it isn't updating. i can put only last row input.. my code is like that: <div id="veriler" align="left"> <?php if(isset($_POST['submit'])) { include "../db.con.php"; $total = $_POST['total']; $i = 0; $vize = $_POST['vize']; $final = $_POST['final']; $but = $_POST['but']; $devamsizlik = $_POST['devamsizlik']; for($i = 1; $i <= $total; $i++) { if(isset($_POST["d$i"])) { $idgoster = $_POST["d$i"]; echo $idgoster; mysql_query("UPDATE `database` SET vize = '$vize' , final = '$final' , but = '$but' , devamsizlik = '$devamsizlik' WHERE id= '$idgoster' ") or die ( mysql_error()); $td++; } } mysql_close($con); } ?> <form method="POST" action=""> <?php include "../db.con.php"; $derskodu = $_GET['derskodu']; $query = "SELECT id,derskodu,ogrencino,adsoyad,vize,final,but,durum,devamsizlik FROM `database` where derskodu='$derskodu'"; $result = mysql_query($query) or die ( mysql_error()); $renkchange=0; $n=0; $i=0; echo '<table border=0 width="800" cellpadding="0" bordercolor="#C0C0C0" cellspacing="0">'; while(list($id, $derskodu, $ogrencino, $adsoyad, $vize, $final, $but, $durum, $devamsizlik) = mysql_fetch_array($result)) { $n++; $i++; $renkchange++; if (($renkchange % 2)== "0"){ $renk="#f5f5f5";} else { $renk="#e5e5e5";} ?> <tr bgcolor="<?php echo $renk;?>"> <input type="hidden" name="<?php echo 'd'.$n;?>" value="<?php echo $id;?>"> <td width="150" class="no"><?php echo $ogrencino; ?></td> <td width="240" class="adsoyad"><?php echo $adsoyad; ?></td> <td width="60" class="vize"><input class="inputx" type="text" value="<?php echo $vize;?>" name="vize" size="3" maxlength="3"></td> <td width="60" class="final"><input class="inputx" type="text" value="<?php echo $final;?>" name="final" size="3" maxlength="3"></td> <td width="60" class="but"><input class="inputx" type="text" value="<?php echo $but;?>" name="but" size="3" maxlength="3"></td> <td width="130" class="devam"> <input type="radio" class="check" value="0" name="<?php echo $ogrencino; ?>" checked> Geçti <input type="radio" class="check" value="1" name="<?php echo $ogrencino; ?>"> Kaldı</td> <td width="100" class="durum"><?php if($durum == "0"){echo "ALIYOR";} elseif ($durum == "1") {echo "GEÇTİ";} else {echo "KALDI";} ?></td> </tr> <?php } echo '</table>'; mysql_close($con); ?> <input name="total" type="hidden" id="total" value="<?php echo $n;?>"> <br><br><input class="buton" type="submit" value="Kaydet" name="submit"> </form> </div> PHP:
i found solution.. =) <div id="veriler" align="left"> <?php if(isset($_POST['submit'])) { include "../db.con.php"; $total = $_POST['total']; $i = 0; $devamsizlik = $_POST['devamsizlik']; /* for($i = 1; $i <= $total; $i++) { if(isset($_POST["d$i"])) { $idgoster = $_POST["d$i"]; echo $idgoster; mysql_query("UPDATE `database` SET vize = '$vize' , final = '$final' , but = '$but' , devamsizlik = '$devamsizlik' WHERE id= '$idgoster' ") or die ( mysql_error()); } } */ while ($i <= $total) { $i++; $vize = $_POST[vize.$i]; $final = $_POST[finalz.$i]; $but = $_POST[but.$i]; if(isset($_POST["d$i"])) { $idgoster = $_POST["d$i"]; mysql_query("UPDATE `database` SET vize = '$vize' , final = '$final' , but = '$but' , devamsizlik = '$devamsizlik' WHERE id= '$idgoster' ") or die ( mysql_error()); $td++; } } mysql_close($con); } ?> <form method="POST" action=""> <?php include "../db.con.php"; $derskodu = $_GET['derskodu']; $query = "SELECT id,derskodu,ogrencino,adsoyad,vize,final,but,durum,devamsizlik FROM `database` where derskodu='$derskodu' ORDER BY `database`.`ogrencino` ASC"; $result = mysql_query($query) or die ( mysql_error()); $renkchange=0; $n=0; $i=0; echo '<table border=0 width="800" cellpadding="0" bordercolor="#C0C0C0" cellspacing="0">'; while(list($id, $derskodu, $ogrencino, $adsoyad, $vize, $final, $but, $durum, $devamsizlik) = mysql_fetch_array($result)) { $n++; $i++; $renkchange++; if (($renkchange % 2)== "0"){ $renk="#f5f5f5";} else { $renk="#e5e5e5";} ?> <tr bgcolor="<?php echo $renk;?>"> <input type="hidden" name="<?php echo 'd'.$n;?>" value="<?php echo $id;?>"> <td width="150" class="no"><?php echo $ogrencino; ?></td> <td width="240" class="adsoyad"><?php echo $adsoyad; ?></td> <td width="60" class="vize"><input class="inputx" type="text" value="<?php echo $vize;?>" name="vize<?php echo $n;?>" size="3" maxlength="3"></td> <td width="60" class="final"><input class="inputx" type="text" value="<?php echo $final;?>" name="finalz<?php echo $n;?>" size="3" maxlength="3"></td> <td width="60" class="but"><input class="inputx" type="text" value="<?php echo $but;?>" name="but<?php echo $n;?>" size="3" maxlength="3"></td> <td width="130" class="devam"> <input type="radio" class="check" value="0" name="<?php echo $ogrencino; ?>" checked> Geçti <input type="radio" class="check" value="1" name="<?php echo $ogrencino; ?>"> Kaldı</td> <td width="100" class="durum"><?php if($durum == "0"){echo "ALIYOR";} elseif ($durum == "1") {echo "GEÇTİ";} else {echo "KALDI";} ?></td> </tr> <?php } echo '</table>'; mysql_close($con); ?> <input name="total" type="hidden" id="total" value="<?php echo $n;?>"> <br><br><input class="buton" type="submit" value="Kaydet" name="submit"> </form> </div> PHP: