From database to HTML table

COLT · January 7, 2021, 11:40am

Hi guys,
I have a problem displaying some database data in an HTML table.
The records in the database are in the following format (color, size, price): ex.

Black S 10.98
Black M 11.23
Black L 12.12
Red M 11.23
Red XL 13.19
Blue L 13.00
…
And now I should print it in the table in the following format as in the picture.

Screenshot_1

Thanks.

benanamen · January 7, 2021, 4:05pm

Are you saying all the data for a product is in a single DB column? If so, that is your REAL problem. Learn about Database Normalization and fix your DB.

COLT · January 7, 2021, 5:00pm

No, those are three colums (there is much more of them but i need only those three).
color_name: ex. Black
label_size: ex. XL
price: ex. 10.77

phdr · January 7, 2021, 7:36pm

I recommend indexing/pivoting the data, using the color and size as the array indexes, when you retrieve the data, so that you can directly access any value when you loop to produce the output, without requiring you to repeatedly loop over all of the data to find and display each value.