In this article I’m showing how to retrieve result based on today, week and month using mysql query. To learn the techniques just visit http://thinkdiff.net/mysql/getting-rank-today-this-week-and-this-month/
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
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]