ok, I have this table
id points
1 123
2 321
3 2
4 1
5 3
6 1233
7 51233
8 123
9 855
10 21
11 12
12 89
13 65
14 21
15 23
I want to list the top 5.
$resultaat=mysql_query("SELECT * FROM table ORDER BY points LIMIT 0,5");
it list…
1
12
123
123
1233
but i want to list for the highest number for 5 later…
thus,
51233
1233
855
321
123
How can i do that… with SELECT.
