max() from mysql-result

Anon

Hello everyone!
I´ve got a small problem that I hope you can help me with...

I have this query that retrieves info from a db and then processes the info in my script. Now, I want to fetch the highest grade (it's soccerteams) from the results ($getdata1).

My query:
$getdata1 = mysql_query("select * from MATCHDATA_PLAYERS right join MATCHDATA_TEAM using (row_id) left join PLAYERDATA using (ID) where turn=$turn and type='$t' and team_id=$id ORDER BY pos ASC");

How can I get the highest grade, without having to query the database again?

The idea is this:
$maxgrade = max(grade) from $getdata1

Please help me out!

Thanks
Vasse

Anon

you almost got it Vasse,

but as far as i know it should look like that:

$sql = "SELECT max(grade) FROM from $getdata1";

Then use $sql and make a mysql_query() and then you will get the highest grade from you table $getdata1

Hope it helped a bit

regards ali

Anon

Let me just get this clear - you want the max(grade) from the data returned by that select statement? Do you want all the rest of the data returned by the query as well? if not, just replace the "*" (which is bad SQL design anyway) with "max(grade)".

If you do want the rest of the data (I'm guessing you do) and you don't want to make the query again, you'll have to get PHP to crawl through the result sets for it.

Annoyingly, you can't go "SELECT *,max(grade) FROM ...." because that would be mixing rows of data with aggregate functions, and for some reason having

Country | ... | grade | max(grade)
SENEGAL | ... | 2 | 4
FRANCE | ... | 1 | 4
JAPAN | ... | 4 | 4

Is a no-no.