CODE EXAMPLE FOR SQL

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