Interested to Buy Any Domain ? << Click Here >> for more details...
we store and display scores of users in different games. In
MySQL, records are stored as tuples (user-id, game-id, score).
Now we need to support ranks of users, i.e., each user
should be informed of his current rank in the community. The
challenge is to come up with the best way to store the data
in MySQL so that the requirements are efficiently met.
- 1 Answers
- 3485 Views
- IndiaTimes, I also Faced
- E-Mail Answers
Answer Posted / amitverma
There's NO need to store the data in any "new" way because
the existing schema/tuple (user-id, game-id, score) is
enough for fetching and displaying the ranks of individual
users. Only need is to write few good SQL queries which
will do the job. We can display ranks as follows -
Select user-id, score from game_table where game-id='10'
order by score.
Note - The above SQL query will display the rankwise
listing of users (as per their scores) for a specific game,
which has id 10 (say cricket).
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is the functionality of md5 function in php?
What is a query give example?
How to get number of days between two given dates using PHP?
Does strlen include null?
How can you create a session in php?
Which function is used in php to delete a file?
Explain how you can update memcached when you make changes to php?
How to convert one date format into another in php?
What do you mean by having php as whitespace insensitive?
Differences between get and post methods?
What is the use of die in php?
What are the different tables(engine) present in mysql, which one is default?
Which function is used to read a file removing the html and php tags in it upwork?
Why die is used in php?
How to use http headers inside php?
