ช่วยดูโค้ด หน่อยคับ คือ ผมเขียน ดึงข้อมูล จาก DB มา พร้อมรับค่าด้วย แล้วจะส่งไปอัพเดท ตารางเดิมยังไง

  <? 			  
$strSQL = "SELECT * FROM score WHERE  score_year = '".$_GET["yearloan"]."' AND score_faculty = '".$_GET["facultyloan"]."'";
$objQuery = mysql_query($strSQL) ;
$i=0; while($i<=$objResult = mysql_fetch_array($objQuery)) {     ?>
                  <tr>
                    <td width="103"><?  echo $objResult["nisit_id"]; ?></td>
                    <td width="299"><? echo $objResult["score_name"];?></td>
                    <td width="60"><? echo $objResult["scored_check"];?></td>
                    <td width="90"><input name="score2[<? echo $i?>]" type="text" id="score2" size="15" /></label></td>
                    <td width="90">
                    <input name="score3[<? echo $i?>]" type="text" id="score3" size="15" /></td>                
                    
                  </tr>
                  <? $i++; } ?>
              </table>
              <input name="score_year" type="hidden" value="<? echo $_GET["yearloan"]?>" />
              <input name="score_faculty" type="hidden" value="<? echo $_GET["facultyloan"]?>" />
              <input type="submit" name="button2" id="button2" value="บันทึก" />
              <input type="submit" name="button3" id="button3" value="ยกเลิก" />
              </form> 
              
              <? } ?>

<?php
if(isset($_POST["score2"] , $_POST["score3"])){
     foreach($_POST["score2"] as $key => $val){
          $sql = "update tb set score2 = $val , score3 = {$_POST["score3"][$key]} where scoreyear='{$_POST["score_year"]}' and scorefaculty = '{$_POST["score_year"]}' ";
          // ............ update executed 
     }
}
?>

<?php
if(isset($_POST["score2"] , $_POST["score3"])){
     foreach($_POST["score2"] as $key => $val){
          $sql = "update tb set score2 = $val , score3 = {$_POST["score3"][$key]} where scoreyear='{$_POST["score_year"]}' and scorefaculty = '{$_POST["score_year"]}' ";
          // ............ update executed 
     }
}
?>

Code (PHP)
[php]<?php
$sqlScore = "SELECT * FROM score WHERE score_year = $score_year  AND score_faculty = $score_faculty  ";

$sqlQuery = mysql_query($sqlScore);
$objResult = mysql_fetch_array($sqlQuery)



if(isset($_POST["score2"] , $_POST["score3"])){
     foreach($_POST["score2"] as $key => $val){
          $sql = "update tb set score2 = $val , score3 = {$_POST["score3"][$key]} where scoreyear='{$_POST["score_year"]}' and scorefaculty = '{$_POST["score_year"]}' ";
          // ............ update executed 
     }
}
?>

<?php
$sqlScore = "SELECT * FROM score WHERE score_year = $score_year  AND score_faculty = $score_faculty  ";

$sqlQuery = mysql_query($sqlScore);
$objResult = mysql_fetch_array($sqlQuery)



if(isset($_POST["score2"] , $_POST["score3"])){
     foreach($_POST["score2"] as $key => $val){
          $sql = "update tb set score2 = $val , score3 = {$_POST["score3"][$key]} where scoreyear='{$_POST["score_year"]}' and scorefaculty = '{$_POST["score_year"]}' and nisit_id='$key' ";
          // ............ update executed 
     }
}
?>