php - 如何根据值显示多个表格

Question

我有一个显示我的信息的库存页面，我试图拥有多个基于部门值(value)的表格，基本上我想在表格中单独显示每个部门而不是单个表格，看起来这会使该页面更容易查看，是的，我是新人，是的，我正在使用 mysql，我知道它已弃用等等，这是一个本地数据库，我是自学成才的。我必须使用某种循环还是有更简单的方法？

<?php
   $connect = mysql_connect("localhost", "Me", "password") or die ("Check your connection.");
   mysql_select_db("radio");
   $quey1="select * from inventory order by department, user";
   $result=mysql_query($quey1) or die(mysql_error());
?>
<table border=1 cellpadding="10 cellspacing="1 style="background-color:#F0F8FF;" >
 <tr>
  <th>Serial Number</th>
  <th>Model</th>
  <th>Department</th>
  <th>User</th>
  <th>Date</th>
 </tr>
<?php
   while($row=mysql_fetch_array($result)){
      echo "<tr><td>";
      echo $row['serialnumber'];
      echo "</td><td>";
      echo $row['model'];
      echo "</td><td>";
      echo $row['department'];
      echo "</td><td>";
      echo $row['user'];
      echo "</td><td>";
      echo $row['date'];
      echo "</td></tr>";
   }
   echo "</table>";
?>

Answer 1

    <?php
   $connect = mysql_connect("localhost", "Me", "password") or die ("Check your connection.");
   mysql_select_db("radio");
   $quey1="select * from inventory order by department, user";
   $result=mysql_query($quey1) or die(mysql_error());
   while($row=mysql_fetch_array($result)){
      $resultsArr[] = $row;
      $departments[] = $row['department'];
   }


foreach($departments as $department) { ?>
  <table border=1 cellpadding="10 cellspacing="1 style="background-color:#F0F8FF;" >
     <tr>
        <th>Serial Number</th>
        <th>Model</th>
        <th>Department</th>
        <th>User</th>
        <th>Date</th>
     </tr>
   <?php foreach($resultArr as $value) 
        if($value['department'] == $department) { ?>
           <tr>
                <td><?php echo $value['serialnumber']; ?></td>
                <td><?php echo $row['model']; ?></td>
                <td><?php echo $row['department']; ?></td>
                <td><?php echo $row['user']; ?></td>
                <td><?php echo $row['date']; ?></td>
           </tr>
   <?php } ?>
<?php } ?>

尝试一下并告诉我是否有效。

罗密欧奥尼西姆