How to???

[X-Weaver]

hey how to continue tables in ranking xD
like Ranking 1 to 25 and in second page 26 to 50 how to make that?

[MentaL]

[Pauliinho]

hmm
the ranking thing will search for places 26-50 then ... you know the rest.

[ZeroCold]

SELECT * FROM Character WHERE Name != '' AND CharNum >= 0 ORDER BY XP desc LIMIT 5, 5

Like that.

This will show records 6, 7, 8, 9, and 10

[wesman2232]

SELECT * FROM Character WHERE Name != '' AND CharNum >= 0 ORDER BY XP desc LIMIT 5, 5

Like that.

This will show records 6, 7, 8, 9, and 10

I thought MSSQL couldn't use the LIMIT thing?

[Guy]

I thought MSSQL couldn't use the LIMIT thing?

It can't; however, it can use the TOP keyword:

http://www.databasejournal.com/featu...erver-2005.htm

[wesman2232]

ya that would be it.
SELECT TOP 10 from Character ORDER BY EXP and so forth :P

[alfredao]

You Need to create a column on char table where shows the ranking of character.

Page 1 - SELECT TOP 25 FROM Character WHERE Ranking => 1 AND Ranking <= 25 ORDER BY XP
Page 2 - SELECT TOP 25 FROM Character WHERE Ranking > 26 AND Ranking <= 50 ORDER BY XP
Page 3 - SELECT TOP 25 FROM Character WHERE Ranking > 51 AND Ranking <= 75 ORDER BY XP

[DreamVolume]

Google -> PHP Pagination with Mssql very helpfull :)

[X-Weaver]

o.o thanks xD im making the ranking page xD thanks very much all guys here hehe