Azu Posted March 11, 2007 Share Posted March 11, 2007 I have some tables and there is a time field in them that is generated by now() and I want to select all of the data that are recent select id from news where (date()-time)<60 That should select all of them that are less then 60 seconds old But it never works, just returns false over and over no matter what doesn't even give me an error it just doesn't work. Please tell me why it's not working and how I can fix it Link to comment https://forums.phpfreaks.com/topic/42265-solved-where-datetime-is-recent/ Share on other sites More sharing options...
Barand Posted March 11, 2007 Share Posted March 11, 2007 WHERE date > NOW() - INTERVAL 60 seconds Link to comment https://forums.phpfreaks.com/topic/42265-solved-where-datetime-is-recent/#findComment-205046 Share on other sites More sharing options...
Azu Posted March 13, 2007 Author Share Posted March 13, 2007 Thanks Link to comment https://forums.phpfreaks.com/topic/42265-solved-where-datetime-is-recent/#findComment-206011 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.