PHP paging

[jonbcheshire]

I have an online rpg.

 

I've reset the round, after running a round since i took over the site.

 

Since the reset, the ranking page count is correct it states at the bottom

 

"1,530 players total | page 1 of 77"

 

...yet the only members displaying are those who have registered since the new round start. The old members are still able to log into the game yet aren't appearing in the admin area or on the rankings page.

 

 

Any ideas where i should start?

[GingerRobot]

Presumably there are two queries running here, one of which generates the total, the other the list of players. I assume there must be a slight difference in the two queries.

[jonbcheshire]

Where can i find someone to take a quick look at this for me?

[jonbcheshire]

When the round ended it appears all data had been deleted from the rankings table. The new users are able to appear on that ranking table it means its working fine.

 

I checked in the user_details table and all the members who were registered previously to the round reset are still in the db.

 

I'm assuming that something has gone wrong during the deletion of the old data if it has done whole rounds before and been fine.