I need a MySQL query (probably simple for experienced users)
I'm sure this is simple for database experts, but I am just a novice user.
I want to count the FREQUENCY of the color occurrences in my database. Basically, col ID is unique, num is my object, color is the color of each object, and str is a string I've collected for each one. What I want to do is write a MySQL query which can run in PHP to count the occurrences of each color, tallying only once for each object.