<script language="javascript">  
function chk_all(){  
    var x=document.getElementsByTagName("input");  
    for(i=0;i<=x.length;i++){  
        if(x[i].type=="checkbox"){  
            x[i].checked=true; 
			}}}
			function unchk_all(){  
    var x=document.getElementsByTagName("input");  
    for(i=0;i<=x.length;i++){  
        if(x[i].type=="checkbox"){  
            x[i].checked=false;  
        }  
    }  
}  
			</script>
<form name="form1" method="POST" action=""> 
  <?php
  require_once "../head.php";
$objConnect = mysql_connect("localhost","root","klw3322") or die("Error Connect to Database");
$objDB = mysql_select_db("klw");
mysql_query("set NAMES tis620");

$strSQL = "SELECT * FROM sportinstall where score='$_GET[id]' group by cl";
$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");

?>
  </p>
  <table width="730" border="1">
  <tr>
     <th > <div align="center"><a href="javascript:chk_all();">เลือกทั้งหมด</a>/<a href="javascript:unchk_all();">ไม่เลือกทั้งหมด </a></div></th> 
	 <th width="190"> <div align="center">สี</div></th>
    <th width="190"> <div align="center">ประเภท</div></th>
    
  </tr>

<?php
while($objResult = mysql_fetch_array($objQuery))
{
	$sportname=$objResult["score"];
?>

  <tr>
    <td align="center"><input name="FilesID[]" type="checkbox" value="<?php echo $objResult["FilesID"];?>"   >
    </td> 
	<td><input name="Name_C[]" type="hidden" value="<?php echo $objResult["cl"];?>" ><?php echo $objResult["cl"];?></td>
    <td><input name="Name_T[]" type="hidden" value="<?php echo $objResult["score"];?>" ><?php echo $objResult["score"];?>
	
	<?       $crsql="SELECT ( sportname ) FROM `sporttyp`
					WHERE id = '$sportname'";
				$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
				$dcrd = mysql_fetch_array($slr);
				$cheke=$dcrd[0];
	             ?>
	
	<? echo "$cheke"; ?>
	</td>
   
  </tr>
<?
	 
  }
  ?>
</table>
<p>
  <input type="submit" name="button" id="button" value="บันทึกข้อมูลที่เลือก" >
</p>
</form>

เตรียมประกาศผล
<?php
if($_POST[button]==""){
exit();
}

for($i=0;$i< count($_POST[FilesID]);$i++){
	 $fid=$_POST[FilesID][$i];
	 $fname= $_POST[Name_C][$i];
	$t= $_POST[Name_T][$i];
	$score= $_POST[m][$i];
	// insert tb2
	$sqlinsert="INSERT INTO  sportpost  (clpost,typ_post,post)  values ('$fname','$t','$score')";
	$objQuery = mysql_query($sqlinsert) or die ("Error Query [".$sqlinsert."]");
	echo "<script>window.alert(\"Save ok\");history.go (-1);</script>";
	//delete from tb 1
	//$sqldelete="Delete  from   tb1   where  FilesID='$fid'  ";
	//$objQuery = mysql_query($sqldelete) or die ("Error Query [".$sqldelete."]");
	//echo "<br>";
}
?>