MySQL date calculation HELP

Broken_Halo2

im trying to figure out how i can get data between certain dates. The dates being between right now and some date in the past. I tryed this but it didn't seem to work. i think i'm confusing myself in how to do it.

$result = mysql_query("select * from nic where RequestedDate > CURDATE() and date_sub(CURDATE(), interval 1 month	)

but i get nothing frmo the database. anyone know what im doing wrong, i'm pretty much new to php so all comments and critisms will be lovely.

nnichols

$sql = "SELECT * 
      FROM nic 
      WHERE RequestedDate < CURDATE() 
      AND RequestedDate > DATE_SUB(CURDATE(), INTERVAL 1 MONTH)";

$result = mysql_query($sql);

This should return records where "RequestedDate" is between the today's date and a month ago.

Hope this helps

bad76

Hi
i think better makes date out of query, like this (i suppose to use datetime and not timestamp...):


$now=date("Y-m-d");
$past=date("Y-m-d",strtotime($now."-1 month"));

$result = mysql_query("SELECT * FROM nic WHERE  RequestedDate BETWEEN ".$now." AND ".$past);

Or just try to insert "BETWEN" in your code instead of ">"

See you