Mysql and PHP grouping

Question

I need to group a query with a detail, the grouping should be done only when the information is repeated in sequence, for example:

id     nome
1      lucas
2      lucas
3      marcos
4      lucas
5      marcos

In the example above, only the "Bowls" with ID’s 1 and 2 can be grouped, the other information is not, because they are not in sequence.

Follows excerpt from the query:

$SQL = "select * from clientes where id = '".$id."' group by nome order by id desc ";
$RSS = mysql_query($SQL, $conexao);
while($RS = mysql_fetch_array($RSS)){
  echo $RS["nome"]."<br>";
}

Answer 1

Instead of using SQL’s GROUP BY, let’s merge the names in sequence in the PHP code.

Would look like this:

$SQL = "SELECT * FROM clientes ORDER BY id";
$RSS = mysql_query($SQL, $conexao);
while($RS = mysql_fetch_array($RSS)){
  if ($RS["nome"] != $nome_atual)
    echo $RS["nome"]."<br>";
  $nome_atual = $RS["nome"];
}

Without the Mysql 'GROUP BY' clause, the names will come in the informed sequence. if checks if the name received from the bank is different from the previous one. If so, it publishes.