Hi,
I would like to select an entry only when the timestamp is less then 5 minutes old.
I tryed: But these did not work, any idea's?
1/ SELECT * FROM track WHERE timestamp < NOW(NOW() - INTERVAL 5 MINUTE) AND id = '$UTS'
2/ SELECT * FROM track_detail WHERE timestamp < SUBDATE(NOW(), INTERVAL 5 MINUTE) AND id = '$UTS'
I would like to select an entry only when the timestamp is less then 5 minutes old.
I tryed: But these did not work, any idea's?
1/ SELECT * FROM track WHERE timestamp < NOW(NOW() - INTERVAL 5 MINUTE) AND id = '$UTS'
2/ SELECT * FROM track_detail WHERE timestamp < SUBDATE(NOW(), INTERVAL 5 MINUTE) AND id = '$UTS'