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?
Code:There are <?php $result = mysql_query("SELECT * FROM organiserdbase", $link); $num_rows = mysql_num_rows($result); echo "$num_rows \n"; ?> Widgets