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 \