In MySQL I have a table of users and many details about them. The problem I have is that I want to give each user a rank based on their level - the highest level = rank1, etc. I have a table, called users. I then want to give each user a rank based on their value in a column called LEVEL. The name of the user is in a column called USER. Can you suggest some code that would work for this situation. I cannot think how I would apply a rank for each users and have been stumped on this for some time.

Thanks

I don't really understand your question. If you want to sort the users based on their level and then apply some rank, I can't see what's so hard.

SELECT user,level FROM users ORDER BY level DESC

Then go through them, one at a time, and apply your ranks. To me it would seem foolish to include this rank in the table, since it would seem as if it can be computed from the level anyway.