Hi,

I'm coding a ranking for my homepage and now I got a problem with the max:

$result = mysql_query("SELECT * FROM ranking ORDER BY points DESC")or die(mysql_error());

It is quite working, but in the end the result is, that there is no echo of the maximum itself.

example:

NAME  POINTS
person1 125
person2 121
person3 123
person4 122
person5 124

the output would look like:

person5 124
person3 123
person4 122
person2 121

how to get an output of the maximum itself?

thanks in advance
Hendrik