Mysql filters the use of group by multiple field combinations when sharing _mysql

To achieve such an effect

If you use GROUP by a condition, the result will be a lot less, how many conditional combination filter?

Copy Code code as follows:

GROUP BY FIELDA,FIELDB,FIELDC ...

The loop can be grouped by judging whether the latter one is the same as the previous one, an example

Copy Code code as follows:

$result = mysql_query ("Select groups,name,goods from Table GROUP by groups,name ORDER by name");
$arr = Array ();
$i = 0;
while ($row = Mysql_fetch_array ($result)) {
$arr [] = $row;
}

$m = $i-1;
foreach ($arr as $k => $v) {
if ($v [$i] [' groups '] <> $v [$m] [' groups ']) {
echo ' Split symbol ';
}
echo $v [' name '], $v [' goods '];
}