PHP MySQL Ranking System

[TheServant]

Hey guys,
Here is my situation: I want to make a ranking system, which will rank users on their points. However the catch is, it should only be updated every 10 or 20 minutes so that ther is no confusion while users are comparing ranks. In the user table I have included a points field as well as a rank field. The points field can get updated over 10 or 20mins easily, that works, however I have no idea how to update ranks in a query. Can anyone shed some light on this?

UPDATE table SET rank=(SELECT rank ORDER BY points WHERE user='username')...

Or something?

[Atli]

Hi.

Your best bet would probably be to create a stored procedure.
Try having it define a cursor to query the user table for the ID of the users, ordered by the score, and update each user's rank based on the position in the query.

[dlite922]

Hey guys,
Here is my situation: I want to make a ranking system, which will rank users on their points. However the catch is, it should only be updated every 10 or 20 minutes so that ther is no confusion while users are comparing ranks. In the user table I have included a points field as well as a rank field. The points field can get updated over 10 or 20mins easily, that works, however I have no idea how to update ranks in a query. Can anyone shed some light on this?

UPDATE table SET rank=(SELECT rank ORDER BY points WHERE user='username')...

Or something?

how are ranks updated? (English version) don't attempt the code. If you explain it to me maybe I can give you a code example.

When you update a rank, how is it accumulated? is it a multiple of the points? i.e. 100 = 1st rank, 200 = 2nd rank, etc. ?






Dan

[TheServant]

Figured out another method. Now I will just update the points every 10 minutes and use a normal ORDER BY MySQL qeury. Before I wanted to have a rank field which was calculated every 10minutes but instead I will calculate ranks on the fly and periodically count the points. Thanks for your help guys.