[SOLVED] Summarising array contents

[padams]

Is it possible to take an associative array and summarise its contents? I have an associative array where each row has an integer playerID field, and a few other fields. What I would like to do is count up how many rows there are for each playerID, and then display that information in a table. I've no idea if it's even possible, and if so, no idea where to start!

 

The query looks like this:

 

$tries_sql = "SELECT * FROM tries";

$tries_query = mysql_query($tries_sql) or die(mysql_error());

$rsTries = mysql_fetch_assoc($tries_query);

[phpwonderkid]

yeah you can use Groupby clause in your query

 

something like

select * from table where 1 groupby playerid

[padams]

Awesome, I didn't know that existed. I've combined it with the COUNT function and it kicks out the results I'm after. Thanks!

 

SELECT tryPlayer, COUNT(tryPlayer) FROM tries GROUP BY tryPlayer