Count equal results from DB, how?

[eluser]aquary[/eluser]
I guess you'll have to normalized the table to count it easier ? I had done something crazier than that (with....everything measurable, fron neck width until length between bib...). but to be simplified for your version...

Table: Items
ID Item_name
1 Tshirts
2 Shirts
3 Hoodies

Table: user_sizes
1 1 M
1 2 M
1 3 XL
2 1 S
2 2 S
2 3 M
3 1 M
3 2 L
3 3 L
4 1 XL
4 2 L
4 3 XL

Then you can use COUNT+GROUP_BY on user_sizes to get sizes summary easily.

Else, you could run a SUM of CASE..... but from the structure, it seems to be a bit hard to archive.