保存按钮，将数据保存在我的本地主机表中

大家好，我使用 fetch 数组创建了一些脚本来显示我的结果，但现在我遇到了问题如何在新表中插入数据结果

---第一页

<?php
 while ($row = mysql_fetch_array($query)) {
 echo "<tr>";
 echo "<td><input type='"text'" name='"grouping'" value='"".stripslashes('NINS_LEC')."'" /></td>";
echo "<td><input type='"text'" name='"InvoiceAccNum'" value='"". stripslashes($row['InvoiceAccNum'])  ."'" /> </td>";
 echo "<td><input type='"text'" name='"AccountFirstName'" value='"".    stripslashes($row['AccountFirstName']) . "'" /></td>";
 echo "<td><input type='"text'" name='"SubsidiaryCode'" value='"". stripslashes($row['SubsidiaryCode']) ."'" /></td>";
 echo "<td><input type='"text'" name='"HandlingCode'" value='"" . stripslashes($row['HandlingCode']) . "'" /></td>";
           echo "</tr>";
       }
    ?>
</table>
   <?echo "$num_rows Rows'n";?>
 <? echo 
"<form name='vw_ob_save' method='get'>
<fieldset>
<table width='680'><tr>
<td colspan='4' align='center'>
<input type='submit' name='btn_save' value='Save'>
</td></tr></table></fieldset></form>";
if(isset($_POST['btn_save'])){
include 'grouping.php';
if($query1>0){
msgalert("data save!");}
}?>

这个现在可以工作了，但是当我的分组.php页面执行时，我的表中只保存了 1 个数据。

分组.php

    <?php
    session_start();
    $username = "root";
    $password = "";
    $hostname = "localhost"; 
    //connection to the database
    $dbhandle = mysql_connect($hostname, $username, $password)
    or die("Unable to connect to MySQL");
    echo "";
    $selected = mysql_select_db("bsswebtool",$dbhandle)
    or die("Could not select bsswebtool");
    if(empty($_POST['form1']))
    {
$grouping                = $_POST['grouping'];
$InvoiceAccNum       = $_POST['InvoiceAccNum'];
$AccountFirstName        = $_POST['AccountFirstName'];
$SubsidiaryCode       = $_POST['SubsidiaryCode'];
$HandlingCode           = $_POST['HandlingCode'];
    }
    else
    {
    $grouping                =null;
$InvoiceAccNum           =null;
$AccountFirstName        =null;
$SubsidiaryCode          =null;
$HandlingCode            =null;
}
 $query1 = "INSERT INTO nins_lec (rid,grouping,InvoiceAccNum,AccountFirstName,SubsidiaryCode,HandlingCode)
 values 
        ('','$grouping','$InvoiceAccNum','$AccountFirstName','$SubsidiaryCode','$HandlingCode')";
mysql_query($query1);
   ?>

我希望我的数据库中有 9 行受到影响，但在签入数据库时只插入了 1 行示例数据结果

   Groupings InvoiceAccNum  AccountFirstName       SubsidiaryCode   HandlingCode
  NINS_LEC    0000000000    ana                             XXXX        D
  NINS_LEC    0000000000    tiana                           XXXX        Q
  NINS_LEC    0000000000    LOPEZ KARL CHU                  XXXX        Q
  NINS_LEC    0000000000    pepe                            XXXX        Q
  NINS_LEC    0000000000    SANTOS                          XXXX        R
  NINS_LEC    0000000000    WONG                            XXXX        Q 
  NINS_LEC    0000000000    BERNALDEZ                       XXXX        R
  NINS_LEC    0000000000    PALICOS                         XXXX        Q
  NINS_LEC    0000000000     JOSE                           XXXX        Q
  9 Rows