In my previous article I’ve shown how to get rank using mysql query. Now I’m showing how to retrieve result based on today, week and month using mysql query. Actually I also implemented this in my quiz project so I’m sharing this with you.
For the table structure please look my previous article http://thinkdiff.net/mysql/how-to-get-rank-using-mysql-query/
Task 1: I’ve to retrieve those users rank who played the game
today.
Solution: Look at the query
SELECT uid, participated, correct, wrong from quiz_user
WHERE DAYOFMONTH(CURDATE())=extract(day from updated)
ORDER BY correct DESC, participated ASC
limit 30
So the above query returns the result of those users who played today. Here
CURDATE() …[Read more]