[SOLVED] problem printing out count function

[amadis]

Hey everyone,

 

I've made a stat database for a softball team. I have all the information in but im having problems printing out some results.

 

the way i have it set up is, a game table, player table and playerstats table. in the playerstats table, i have the game, player and a bunch of stats.

 

I'm trying to print out the names of all the players on the roster and then use COUNT to find out how many games they appear in.

 

when i use this query, it works for 1 predefined player (in the where clause)

 

SELECT player.playerID,player.playerFirstName, player.playerLastName, COUNT(playerstats.playerID)

FROM playerstats INNER JOIN player ON (playerstats.playerID=player.playerID)

WHERE playerstats.playerID='1';

 

however, whenever i take out the where clause, it just prints out the first players name and then counts all the players appearences. IE) Ron Johnson has played 265 games.

 

any ideas what the problem is? thanks!

 

 

[gassaz]

Try this..

 

SELECT player.playerID, player.playerFirstName, player.playerLastName, COUNT(playerstats.playerID)
FROM playerstats INNER JOIN player ON (playerstats.playerID=player.playerID)
GROUP BY playerstats.playerID;

[amadis]

Awesome! thanks so much!!!