help using SUM

[msnhockey]

the code below when exectued returns 10 games that havent been played, what i am trying to accomplish is the code returning the number 10 and not a list of games.

I think I need to use SUM, but not overly sure

any pointers appriciated 😃

SELECT * FROM schedule_scores WHERE (team1 = '3' OR team2 = '3') AND season = '14' AND team1_score = ' ' AND team2_score = ' '

[msnhockey]

nevermind forgot about the COUNT function

SELECT COUNT(*) FROM schedule_scores WHERE (team1 ='3' OR team2 ='3') AND season ='14' AND team1_score =' ' AND team2_score =' '