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
- 3568 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 are php libraries?
Tell me how can we display information of a variable and readable by human with php?
Does PHP 5 support exceptions? State Whether True or False?
What is the difference between get & post ?
What is super () python?
What is different between software and app
How to calculate the length of a string?
What is a string in r?
List data types in PHP?
How to receive a cookie from the browser?
What is the difference between apache vs niginx?
What is difference between session_unset and session_destroy?
How do you pass a variable by value?
What is php call function?
Why echo is faster than print in php?
