If you want it done in the MySQL query, it is honestly more trouble than it's worth. For one, the syntax is really wonky (as I recall) to have a group name listed at the top of each grouping. And the results are still treated as rows, so the group name will be treated like a row with all the other columns as Null, so you won't really save any time or effort in the PHP script as it has to do an if statement to catch when it hits a group name instead of the group data.

如果你想在MySQL查询中完成它,它实际上比它的价值更麻烦。首先,语法非常简单(我记得)在每个分组的顶部列出了一个组名。并且结果仍然被视为行,因此组名称将被视为一行,其他所有列都为Null,因此您不必在PHP脚本中节省任何时间或精力,因为它必须执行if语句当它命中组名而不是组数据时捕获。

If you want it done by the PHP while loop, Johan is on the right track. I use the following for a similar situation:

如果你想通过PHP while循环来完成它,那么Johan就是在正确的轨道上。我使用以下类似的情况:

$result = $sql->query($query);

$prev_group = "";

while($data = $result->fetch_assoc()){
   $curr_group = $data['group'];
   if ($curr_group !== $prev_group) {
      echo "
$curr_group
";
      $prev_group = $curr_group;
    }
    else {
        echo $data;
        .....
     }

Obviously the echo data would be set up to echo the parts of the data the way you want. But the $prev_group/$curr_group is set up so that the only time they won't match is when you are on a new group and thus want to print a header of some sort.

显然,回波数据将被设置为以您想要的方式回显数据部分。但$ prev_group / $ curr_group的设置是为了让它们不匹配的唯一时间是当你在一个新的组上,因此想要打印某种类型的标题。

while($data = mysql_fetch_assoc($result)){
    if($data['product_groups.name'] != $groupname){
        echo "Groupname: ".$data['product_groups.name']."
";
        $groupname = $data['product_groups.name'];
    }
    echo "ID: ".$data['products.id']."
";
    echo "Name: ".$data['products.name']."
";
}

Maybe you can do like this!?

也许你可以这样做!?