MAX(SUM())

[BTW8892]

Hey, i was wondering if it was possible to find the sum of all the values in certain row and than find the max value of all of them. I have the following code, but it only grabs the largest value from all the rows, is it possible to sum all them, and than grab the max based on the persons playerid?

$result = mysql_query("SELECT gamertag, goals FROM player_stats WHERE goals = (select Max(goals) from player_stats)GROUP BY playerid; ");

-----------------------------------------------------

Is it also possible to grab a profile picture from another table based on the code above?

[sDJh]

a) I don't know. And for me it would take too much time to find out. Just write a code like that:

$a=mysql_fetch_row($result);
$sum=array_sum($a);//http://de3.php.net/manual/en/function.array-sum.php
arsort($a);//http://de3.php.net/manual/en/function.arsort.php
$max=$a[0];

b) why not? Save a unique ID for each user in your `player_stats` and `player_pics` and select the image from `player_pics

[BTW8892]

Any other replies?