php - 使用php按类别显示表格

Question

我的数据库设计是这样的

-- Table Reason
--------------------------
| reasonid  | reasonname |
--------------------------
|    1      |  reason1   |
|    2      |  reason2   |
--------------------------
-- Table Student
----------------------------
| studentid  | studentname |
----------------------------
|    1      |     John     |
|    2      |     Jane     |
|    3      |     Hulk     |
----------------------------
-- Table form
-----------------------------------
| formid  | studentid |  reasonid |
-----------------------------------
|    1    |     1     |     1     |
|    2    |     2     |     2     |
|    3    |     3     |     1     |
-----------------------------------

我想像这样显示数据表:

reason1| 1  |  John  || 2  |  Hulk  |reason2| 1  |  Jane  |

I have tried below code but the result is not groupBy reason

<?php $i =1;
      while($rowfet = mysql_fetch_array($myselect)){ ?>
            <h2><?php echo $rowfet['ReasonName']; ?></h2>
            <table>
            <thead>
                <tr class="active">
                <th>No.</th>
                <th>StudentName</th>
                </tr>
            </thead>
            <tbody>
                <tr>
                <td align="center"><?php echo $i; ?></td>
                <td><?php echo $rowfet['STUDENTNAME']; ?></td>
                </tr>
            </tbody>
            </table>
        <?php $i++; } ?>

这段代码的结果是:

reason1
|  1  |  John |
reason1
|  2  |  Hulk |
reason2
|  3  |  Jane |

Answer 1

你可以这样做:

while 循环外:

$lastReasonId = '';

在 while 循环中:

if($rowfet['reasonid'] != $lastReasonId){
    // show heading
}
$lastReasonId = $rowfet['reasonid'];

但是您的代码远非正确。 $i++ 没有做任何事情，你应该在那里回显 $rowfet['studentid'] 。而且您正在使用已弃用的 mysql 代码。