I am trying to display a number of pirticular units in a database. I have the following which shows the total number of units, but not the pirticular units.

For example, the code below will show: There are 11 Widgets.

What I am trying to show is:

There are 4 Red Widgets.
There are 2 Blue Widgets.
There are 5 Green Widgets.

Does anyone know how to do this please?

There are <?php

$result = mysql_query("SELECT * FROM organiserdbase", $link);
$num_rows = mysql_num_rows($result);

echo "$num_rows \n";

?> Widgets