Get data less than 24 hours from current date

[ghjk]

I want to get data less than 24 hours from the current date. This is my query. But i get wrong output. It display 2008-07-22 data and 2008-05-15 data also. Could some one help me?


[PHP]SELECT Rainfall,Date FROM rainfall WHERE TIMEDIFF('".$today."', Date) < '24:00:00' AND Station_ID= '$GStationID' ORDER BY Date ";[/PHP]

[coolsti]

I want to get data less than 24 hours from the current date. This is my query. But i get wrong output. It display 2008-07-22 data and 2008-05-15 data also. Could some one help me?


[PHP]SELECT Rainfall,Date FROM rainfall WHERE TIMEDIFF('".$today."', Date) < '24:00:00' AND Station_ID= '$GStationID' ORDER BY Date ";[/PHP]

It would help if you also tell us the following: What is Date? A Date field or Datetime field? What value does $today take on? The format may be important.

Why don't you just let mysql calculate a value for $today? You can maybe use the NOW() function in mysql.

[ghjk]

It would help if you also tell us the following: What is Date? A Date field or Datetime field? What value does $today take on? The format may be important.

Why don't you just let mysql calculate a value for $today? You can maybe use the NOW() function in mysql.

Date= datetime field
$today = current date
ex:[PHP]$today = date("Y-m-d H:i:s");[/PHP]

[Atli]

Try something like:

SELECT cols FROM table WHERE dateCol > DATE_SUB(NOW(), INTERVAL 1 DAY);
/* OR, if your going into the future*/
SELECT cols FROM table WHERE dateCol < DATE_ADD(NOW(), INTERVAL 1 DAY);
 

It's all in the manual.

[ghjk]

Try something like:

SELECT cols FROM table WHERE dateCol > DATE_SUB(NOW(), INTERVAL 1 DAY);
/* OR, if your going into the future*/
SELECT cols FROM table WHERE dateCol < DATE_ADD(NOW(), INTERVAL 1 DAY);
 

It's all in the manual.

Thank You. It works!