Showing entries 1 to 2
Displaying posts with tag: DATE_SUB (reset)
Feb
28
2010
MySQL query that get ranks today, this week and this month
Posted by Mahmud Ahsan on Sun 28 Feb 2010 07:28 UTC
Tags:

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/

Feb
28
2010
Getting rank today, this week and this month
Posted by Mahmud Ahsan on Sun 28 Feb 2010 07:24 UTC
Tags:

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]
Showing entries 1 to 2