ขอคำแนะนำเรื่องการใช้ mysql_num_rows กับการใช้ตัวแปรร่วมชนิด array กับการให้โชว์ลำดับแถวฟอร์มบันทึกให้พอดีตรงตามข้อมูลที่ num มา สงสัยมากๆครับ

$i=1;
while ($rs1=mysql_fetch_array ($query)) {
	echo "<tr>";
        echo "<td>ลำดับ $i</td>";
        echo "<td>";
        echo "&nbsp;<b>สินค้า:</b>&nbsp;".$rs1["pro_name"];
        echo "&nbsp;จำนวน:&nbsp;".$rs1["qty"]."&nbsp;ชุด";
        echo "</td>";
        echo "</tr>";
        $i++;
}

<?
$i = 1;
$query=mysql_query("select * from request where cus_ord_id = '$search'");
		   while ($rs1=mysql_fetch_array ($query)) {
		             if ( $i == 1 ) {
         			$var_p_code1=$rs1["pro_id"];
					$var_p_qty1=$rs1["qty"];
					$var_p_price1=$rs1["price"];	
					$var_p_name1=$rs1["pro_name"];
                     }	
					  if ( $i == 2 ) {
         			$var_p_code2=$rs1["pro_id"];
					$var_p_qty2=$rs1["qty"];
					$var_p_price2=$rs1["price"];	
					$var_p_name2=$rs1["pro_name"];
                     }			   
					  if ( $i == 3 ) {
         			$var_p_code3=$rs1["pro_id"];
					$var_p_qty3=$rs1["qty"];
					$var_p_price3=$rs1["price"];	
					$var_p_name3=$rs1["pro_name"];
                     }
					  if ( $i == 4 ) {
         			$var_p_code4=$rs1["pro_id"];
					$var_p_qty4=$rs1["qty"];
					$var_p_price4=$rs1["price"];	
					$var_p_name4=$rs1["pro_name"];

                     }
					 $i = $i +1;
                    }
?>

เบิกสินค้าลำดับที่ 1
    </td> 
		<?
		   echo "&nbsp;<b>สินค้า:</b>&nbsp;";
		   	   echo  "<select name='i_p_code1' size='1' value ='' >
                 <option value=''>กรุณาเลือกสินค้า</option> ";
				 $query=mysql_query("select  pro_id ,pro_name from product");
			while ($rs1=mysql_fetch_array ($query)) {
		    $var_p_code1=$rs1['pro_id']; 
			$var_p_name1=$rs1['pro_name']; 
                  echo  "<option value='$var_p_code1'>$var_p_code1&nbsp;-&nbsp;$var_p_name1</option>";
				  }
           echo "</select>";
		    echo "<input type='hidden' name='i_p_qty1' size='11' maxlength='11' value='1'>";
			echo "<input type='hidden' name='var_p_price1' size='11' maxlength='11' value='1'>";
		   echo "&nbsp;รหัสสินค้า:&nbsp;";
	   echo  "<select name='i_p_sn1' size='1' value ='' >
                 <option value=''>กรุณาเลือกรหัสสินค้า</option> ";

		$query=mysql_query("select  r_p_sn,r_p_id  from recive where r_type='SOLD'");
	
		   while ($rs1=mysql_fetch_array ($query)) {
		    $var_p_sn1=$rs1['r_p_sn']; 
			$var_p_id1=$rs1['r_p_id']; 
                  echo  "<option value='$var_p_sn1'>$var_p_id1 : $var_p_sn1</option>";
				  }
           echo "</select>";
				?>	       

         			                        $var_p_code1=$rs1["pro_id"];
					$var_p_qty1=$rs1["qty"];
					$var_p_price1=$rs1["price"];	
					$var_p_name1=$rs1["pro_name"];

         			                        $var_p_codex=$rs1["pro_id"];
					$var_p_qtyx=$rs1["qty"];
					$var_p_pricex=$rs1["price"];	
					$var_p_namex=$rs1["pro_name"];  ....

if ($i_p_sn1 != ''  || $i_p_code1 != '') {          
      $var_i_date = date ("d/m/y") ;
      $sum_qoh =0;
     $resulte = mysql_query("select  cus_user,qty,price from request  where cus_ord_id = '$i_q_no' and  pro_id = '$i_p_code1' ");
     $rec=mysql_fetch_array($resulte);
     $i_cus_code1 = $rec['cus_user'];
     $i_s_price1 = $rec['price'];

	 $resulte = mysql_query("select  cus_ord_com,cus_ord_name,total from cus_order  where cus_ord_id = '$i_q_no' ");
	$rec=mysql_fetch_array($resulte);
	$i_cus_name=$rec['cus_ord_name'];
	$i_cus_com=$rec['cus_ord_com'];
	$i_total=$rec['total'];

     $resulte = mysql_query("select  pro_min from product  where pro_id = '$i_p_code1'");
     $rec=mysql_fetch_array($resulte);
     $var_i_qoh = $rec['pro_id'];
    $var_s_qty = $rec['pro_min'];

      $var_person =  $username;
	 // $i_d_qty = 0 ; 
     // $i_r_qty = 0 ;
      $i_b_start = '';  
      $i_b_finish = ''; 
	  $i_remarks = '';
	   $var_y= substr($dates,6,4) + 543;
	   $var_m = substr($dates,3,2);
	   $var_d = substr($dates,0,2);
	   $i_s_start = $var_d."/".$var_m."/".$var_y;
	   $var_y= substr($datef,6,4) + 543;
	   $var_m = substr($datef,3,2);
	   $var_d = substr($datef,0,2);
	   $i_s_finish = $var_d."/".$var_m."/".$var_y;

     $sum_s_qty = $var_s_qty - $i_p_qty1 ;
	 $note = "ซื้อสินค้าแล้ว";
      $query=mysql_query("insert into issue(i_no,i_p_code,i_p_sn,i_date,i_cus_user,i_cus_name,i_cus_com,i_qty,i_type,i_s_price,i_s_remarks,i_s_start,i_s_finish,i_person,i_q_no) values('','$i_p_code1','$i_p_sn1','$var_i_date','$i_cus_code1','$i_cus_name','$i_cus_com',1,'$i_type','$i_s_price1','$i_remarks','$i_s_start','$i_s_finish','$var_person','$i_q_no')");
	  $query=mysql_query("insert into order_list set
	  ord_id = '' , ord_date = CURDATE() , ord_name = '$i_cus_name' , ord_com = '$i_cus_com' , ord_q_no = '$i_q_no' , ord_total = '$i_total' , ord_user = '$i_cus_code1' ");
      $query=mysql_query("update  product  set  pro_min = '$sum_s_qty' where pro_id = '$i_p_code1'");
      $query=mysql_query("update  recive  set  r_type = 'OUTS'  where r_p_id = '$i_p_code1' and r_p_sn = '$i_p_sn1'");   
	  $query=mysql_query("update	 cus_order  set  cus_ord_note = 'finish!' where cus_ord_id = '$i_q_no'");