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.
Answer / 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 |
hello experts good morning to everyone ! at present am now learning LAMP course sir( linux, apache,mysql and php) after finishing this course can i create my own website without investment is it possible ? please can any one tell sir and also tell me how can i upload my project after finishing the project in internet ? please tell the ways sir please send ur valuable suggestions to kiranpulsar2007@gmail.comcom
How to set session.gc_maxlifetime properly?
I finished my degree 4 years back. I didnt get job in software. In the time(for 4 years) i worked one kpo industries. but now i got job in php(40 employes working there) as fresher(Salary 8000). Shall i join in php. I have no knowledge about php. Can i do well in php. How will my carrier if i join in php? Please can you give your idea.? It will be more usefull to me.
What is PEAR in PHP?
What does the initials of php stand for?
how much can a 1yr experienced php programmer earn in india?
9 Answers TCS, Tops Technologies,
Which php global variable is used for uploading a file?
Is string php function?
how to count how many sundays in month?
Will react hooks replace redux?
What type of headers that PHP supports?
How to write in a file in php?