[PhP+MSSQL]rank count with pages

[katsumi]

Finally i figured out to generate pages
1 small bug now


the first page shows like
Rank
1
2
3
4
5

the next page also shows same

i want it like the one below in page 2

6
7
8
9
10

 

[shadow-xx]

MSSQL doesent have a good limit function like MySQL has

Use top and order by instead.. in 1 query with a subquery