Hey all, Im just having some trouble with some code. I'm trying to select all records from a mysql database between now and 24 hours ago. What I have so far is.

$get = mysql_query("SELECT * FROM teams WHERE section='$sec' AND date_time_added < NOW() ORDER by id DESC LIMIT $start, $per_page");

I just dont know how the syntax should be structured to select between "NOW" and 24 hours ago.

-Worldy

Try,
SELECT * FROM teams WHERE date_time_added < DATE_SUB(NOW(), INTERVAL '24' HOUR)


Credits:
Knowledge previously inherited by Chrishirst & forcing me to learn more SQL.

Okk I gave that a try, but it gives me results from 24 hours hours onward, instead of between 24 hours and now.

Sorry change:
SELECT * FROM teams WHERE date_time_added < DATE_SUB(NOW(), INTERVAL '24' HOUR)

to

SELECT * FROM teams WHERE date_time_added > DATE_SUB(curdate(), INTERVAL 1 DAY)
or
SELECT * FROM teams WHERE date_time_added > DATE_SUB(curdate(), INTERVAL '1' DAY)
or
SELECT * FROM teams WHERE date_time_added > DATE_SUB(NOW(), INTERVAL '1' DAY)
or
SELECT * FROM teams WHERE date_time_added > DATE_SUB(NOW(), INTERVAL 1 DAY)


All 4 of the above should work, However try them from top to bottom.
you can try changing curdate() to now() but the above should work ( seems to work here )

Thanks It works!

Originally Posted by bradtraversy

Hi

well one simple way could be such as:

SELECT * FROM `log` WHERE `time` > UNIX_TIMESTAMP() - 3600 * 12

SELECT * FROM `log` WHERE `time` > UNIX_TIMESTAMP() - 3600 * 24

SELECT * FROM `log` WHERE `time` > UNIX_TIMESTAMP() - 3600 * 36




Thanks

Problem here being the unix timestamp can be different to the DB timestamp.. So its not the most reliable.