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
- 3503 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 does mvc stand for and what does each component do?
What is a trait in php?
Explain me what is the meaning of a persistent cookie?
What are encryption functions in php?
So if md5() generates the most secure hash, why would you ever use the less secure crc32() and sha1()?
Why should I store logs in a database rather than a file?
Tell me how can we pass the variable through the navigation between the pages?
How to return a value back to the function caller?
Steps for the payment gateway processing?
What is use of preg_replace in php?
What is the default time in seconds for which session data is considered valid?
Is not null mysql?
Can we extend two classes in php?
What is the function of string in c?
Tell us how can we display the output directly to the browser?
