sorting recordsets

[MasonAtom]

Is there was way to use php to sort a series of recordsets by a selected value and display the sorted recordsets?

For example: say I have a database that keeps track of a basketball team - the main table (table_stats) has the player's names, the dates of the games, and the number of points the player scored in the particular game. There are 5 players (sam, cindy, greg, nancy, and vladamirovski) and each played 4 games.

I can make a recordset for each individual player to add their total points as such:

select sum(points) from table_stats where name = 'sam'

Now, is there a way to use php to sort these 5 recordsets for sum(points) and display the results in descending order?

Mason

[LordShryku]

No real point in doing them individually....

Why not select them all together into one recordset and use an order by statement?

[tsmith]

How about this:
$sql = "select sum(points) as points_scored, player_name from game_stats group by player_name order by points_scored desc"

This would actually have mysql do the processing, but you would get the players name and score total, ordered by total.

HTH,
-ts

[MasonAtom]

Thanks for the help. Its working great so far.