I have a mysql table with these columns:
series_id, series_color, product_name
In the output, I want to list the data by sections, one section per series_id
like this:
A12 Series Product - Milk - Tea - sugar - water B12 Series Product - Water - Banana - Cofee - Tea
Sort the results by
series_id
so all products with the same value will be together.Then, when displaying the results, display the series title and start a new one if it changes
: