counting occurences

[buducom]

Lets say i do a select on 100 records from mysql
then i have 20 who are marked red some are blue 40 are green.
Should i make a selection for each color to determine with mysql_num_rows how much there are or is
it doable with 1 select and use loops and counter variables?
whats better whats faster?

dan

[paulnaj]

Hi bud,

Anywhere you read about MySQL, it always says that its faster to get MySQL to do the work than PHP.

With that in mind, 3 sql queries is probably faster, but you'll only notice the difference if you have to query 1000's of rows rather than 100's.