MYSQL not returning results between dates are in different years

Question

I am attempting to find records that fall between 2 dates. My dates are set in 2 php variables, today's date and then 8 weeks before today. The code works when the 2 variables are within the same year, but when the date falls in the previous year, no results are found; i.e. $today = 28 Jan 2014 and $lastmonth = 3 Dec 2013. The variables seem to be calculating correctly when I look at the date results. What is causing the problem?

<?php
$today = date('Y-m-d');
$lastmonth = date('Y-m-d', strtotime('-8 week', strtotime($today)));

$sql = mysql_query("SELECT * FROM products WHERE dated_release BETWEEN '$lastmonth' AND '$today' ORDER BY code");

$existCount = mysql_num_rows($sql); // count the row nums
if ($existCount > 0) { // evaluate the count and build display
// more code

?>

The dated_release field in the table has been set up as a date field. This is my first website using php and mysql.

silly · Accepted Answer · 2014-01-28 10:36:14Z

0

you can create a simple query like this

SELECT *
FROM products
WHERE dated_release BETWEEN NOW()
    AND DATE_ADD(NOW(), INTERVAL -8 WEEK);

answered Jan 28, 2014 at 10:36

silly

7,8972 gold badges27 silver badges37 bronze badges

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

Collectives™ on Stack Overflow

MYSQL not returning results between dates are in different years

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related