count rows with same group by mysql code example

Example: mysql group rows with same value

/**
 * Used <br> to list itens one below the other in HTML page
 */
group_concat(p.nameItem separator '<br>') as listProdItem