mysql between query in dates

Question

$currentdate = date("Y-m-d");
$lastweekdate = date("Y-m-d", strtotime("-6 days")); 
$querytopscoreofweek  = 
"SELECT * FROM fb_user WHERE  last_date".
" BETWEEN $lastweekdate AND $currentdate ORDER BY oldscore DESC LIMIT 0,10";

i have field name last_date in this format $currentdate = date("Y-m-d"); i want to execute the above query i want it to return all the users of last week and mean between $lastweekdate and $currentdate and which has also old_score greater in descending order and only 10 users,BUT THE PROBLEM IS THAT IT IS NOT RETURNING ANY THING ANY HINT PLZ

this looks okay. Is last_date a date field? Are you 100% sure it contains accurate data? — Pekka
– Pekka, Commented Mar 4, 2011 at 21:52

dmcnelis · Accepted Answer · 2011-03-04 22:05:04Z

1

SELECT * 
FROM fb_user 
WHERE last_date BETWEEN curdate() AND curdate() - interval 6 day 
ORDER BY oldscore DESC LIMIT 10

edited Mar 4, 2011 at 22:05

dmcnelis

2,9231 gold badge21 silver badges28 bronze badges

answered Mar 4, 2011 at 21:52

Nicola Cossu

56.7k15 gold badges96 silver badges99 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

mysql between query in dates

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related