我想让“serienumer”的数据列表根据所选的“产品”进行更改。

<td>Product</td>
              <td>
                <Select name="ProductID" placeholder="Productnaam" required>
                  <?php
                  $query2 = "SELECT DISTINCT ProductID FROM HW_Serial WHERE Prefix = '$prefix'";
                  $result2 = mssql_query($query2);
                  $numRows = mssql_num_rows($result2);
                  while($row = mssql_fetch_array($result2))
                  {
                    $DisProductID=$row["ProductID"];
                    $query3 = "SELECT ProductID, ProductName FROM Products WHERE ProductID = '$DisProductID' order by ProductName";
                    $result3 = mssql_query($query3);
                    $numRows = mssql_num_rows($result3);
                    while($row = mssql_fetch_array($result3))
                    {
                      $xProductID=$row["ProductID"];
                      $xProductName=$row["ProductName"];
                      if ($ProductID == $xProductID) {
                        echo "<OPTION value =\"$xProductID\">$xProductName</OPTION>";
                      } else {
                        echo "<OPTION value =\"$xProductID\">$xProductName</OPTION>";
                      }
                    }
                  }
                  ?>
                </select>
              </tr>
              <tr>
                <td>Serienummer</td>
                <td>
                  <input list="devicesn" name="devicesn" autocomplete="off" placeholder="Serienummer" required>
                  <datalist id="devicesn">
                    <?php
                    $query2 = "SELECT devicesn FROM HW_Serial WHERE ProductID = '$ProductID' order by devicesn";
                    $result2 = mssql_query($query2);
                    $numRows = mssql_num_rows($result2);
                    while($row = mssql_fetch_array($result2))
                    {
                      $xdevicesn=$row["devicesn"];
                      if ($devicesn == $xdevicesn) {
                        echo "<OPTION value =\"$xdevicesn\">$xdevicesn</OPTION>";
                      } else {
                        echo "<OPTION value =\"$xdevicesn\">$xdevicesn</OPTION>";
                      }
                    }
                    ?>

我的猜测是，这必须通过使用javascript来完成，但说到这一点，我是一个完全的初学者。
提前谢谢