ขอถามเรื่องการวนloopเพื่อแสดงข้อมูลในrecord และบันทึกข้อมูลลงdatabaseของแต่ละrecordนั้นๆ(ช่วยด้วยนะคะ)

<script language="JavaScript">
function on_submit(obj,id)
{
obj.action = 'add_zone1.php?id='+id;
obj.submit();
}
</script>


<form method="post">
<table>
<? 
include("config.php");   
$sql_rooms=mysql_query("select*from rooms where  room_zone=1 order by room_id asc " ); 
while($show_rooms=mysql_fetch_array($sql_rooms)){ ?>
<tr bgcolor="#ffff99" bordercolor="#996600">
<td align=center ><?echo $k?></td>
<td align=center><?echo $show_rooms[room_id]?></td>
<td align=center><?echo $show_rooms[water_be]?></td>
<td align=center><input type="text" name="water_af[<?=$k?>]" size="5"></td>
<td align=center><input  type="button" value="ok" onclick="on_submit(this.form,'<?echo $show_rooms[room_id]?>')"></td>
<? }?>
</tr>
</table>
</form>
 
 
<? // เวลาเก็บข้อมูล
mysql_query("insert into rooms(water_af)values('$water_af[$id]')"); 
mysql_query("update rooms set water_af='$water_af[$id]' where room_id='$id' ");
?>

<form method="post" action="add_zone1.php">
<table border="1"  align=center width="700" cellspacing="0">
		<tr bgcolor="#996600" align=center bordercolor="#996600">
		<td width="10%" ><font  color="#ffffff">ลำดับที่</font></td>
	    <td width="20%"><font  color="#ffffff">เลขที่ห้อง</font></td>
	    <td width="20%"><font  color="#ffffff">มิเตอร์น้ำงวดก่อน</font></td>
	    <td width="20%"><font  color="#ffffff">มิเตอร์น้ำงวดปัจจุบัน</font></td>
</tr>
<?
	include("config.php");
	$sql_rooms=mysql_query("SELECT * FROM rooms WHERE  room_zone=1 ORDER BY room_id ASC " );
	while($show_rooms=mysql_fetch_array($sql_rooms)){
	?>

<?$i++?>
<tr bgcolor="#ffff99" bordercolor="#996600">
<td align=center ><?echo $i?></td>
<td align=center><input type="hidden" name="room_id[]" value="<?=$show_rooms[room_id];?>"><?=$show_rooms[room_id];?></td>
<td align=center><?echo $show_rooms[water_be]?></td>
<td align=center><input type="text" name="water_af[]" size="5"></td>
</tr>
<?
	}
?>
<tr>
	<td colspan="4" align="right"><input type="submit" value="[บันทึกข้อมูล]"></td>
</tr>
</table>
</form>

<?php
include ("config.php");
$roomd_id=$_POST[roomd_id];
$water_af=$_POST[water_af];
$count = count($roomd_id);

for($i=0;$i<$count; $i++){
	if ($water_af[$i] != ""){ 
		mysql_query("INSERT INTO rooms(water_af) VALUES('".$water_af[$i]."')");
		mysql_query("UPDATE rooms SET water_af='".$water_af[$i]."' WHERE room_id='".$room_id[$i]."' ");
	}
}
header("location:zone1.php");
?>