Counting Record Values

[ultramagnus]

I have setup a table that will contain data for baseball games. I have defined the GScheduleResult field as a CHAR (1). The values of the that field will be a 'W' or 'L'. Is there a way using PHP, that I can count all the 'W''s and all the 'L's so I can then display those counts to show the overall record for a team?

[Mark Baker]

You don't even need PHP, you can do it with a SQL query

 

select team,
       GScheduleResult,
       COUNT(*) as Count
  from tableName
group by team,
          GScheduleResult

[ToonMariner]

also performance wise use enum rather than char(1)