Count equal results from DB, how?

[eluser]iGeordie[/eluser]
Try something such as the following:

Code:

SELECT size, COUNT(*) AS size_count FROM T-Shirts GROUP BY size

Should be a simple case of outputting a table row per $row returned as so:

Code:

<tr><td>$row['size']</td><td>$row['size_count']</td></tr>

I could go into more depth, let me know if you want help with the full solution but I expect this should get you started.

Let me know how you get on.