Compare date in MySQL with Current Date Minus 3 Days and display or email

Databases
1

I am unable to solve this and request help.

I have a Table in MySQL with Date field and date is in format (2011-08-12)

I wish to run query to get me result only where Current Date - 3 Days = Date in Database column

I use this query :
SELECT * FROM table WHERE date_booked <= CURRENT_DATE AND date_booked >= ( CURRENT_DATE - INTERVAL 3 DAY )

This does not give me data of query data of 2011-08-12 if today is 15th Aug that is 3 days ago.

When I run this it gives me data of today !
Below is my code :

<?php

error_reporting(-1);
ini_set(‘display_errors’, true);

include_once “connect_to_mysql.php”;

$sql = mysql_query(“SELECT * FROM dtdctri WHERE date_booked <= CURRENT_DATE AND date_booked >= ( CURRENT_DATE - INTERVAL 3 DAY )”);

echo “<table border=‘1’>
<tr>
<th>Shipping Number</th>
<th>Sender Name</th>
<th>Sender Email</th>
<th>Date Entered</th>
<th>Date Booked</th>
</tr>”;

while($row = mysql_fetch_array($sql)) {
echo “<tr>”;
echo “<td>” . $row[‘shpngnumber’] . “</td>”;
echo “<td>” . $row[‘sendername’] . “</td>”;
echo “<td>” . $row[‘email’] . “</td>”;
echo “<td>” . $row[‘date_entered’] . “</td>”;
echo “<td>” . $row[‘date_booked’] . “</td>”;
echo “</tr>”;

}

echo “</table>”;

?>

Thanks in advance

2

that query is fine

are you sure you’re using a DATE column? perhaps you could to a SHOW CREATE TABLE for your table to confirm

3

Yes I am using a DATE Column and below is Create Table view.

CREATE TABLE dtdctri (
id int(11) NOT NULL AUTO_INCREMENT,
shpngnumber varchar(20) NOT NULL,
sendername varchar(50) NOT NULL,
email varchar(50) NOT NULL,
date_entered date NOT NULL,
date_booked date NOT NULL,
sent enum(‘pending’,‘reminder_sent’,‘delivered’) NOT NULL,
PRIMARY KEY (id)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=latin1

When I run PHP script it shows me DATA in column with Date as 15th whereas I want it to shoe me data of 12th Aug i.e 3 days before than current date.

4

use this query:

SELECT * 
  FROM dtdctri 
 WHERE date_booked = CURRENT_DATE - INTERVAL 3 DAY
5

Many Thanks for your support. This works fine now…

Cheers