How do you issue SELECT to select items posted in last X seconds?
For example for last 60 Seconds.
I have tried this:
SELECT * FROM xyz
WHERE ip = '$ip'
AND date_added > (DATE_SUB(CURDATE(), INTERVAL 60 SECOND))
ORDER BY id DESC;
But this does not return correct results as the list that it returns is not limited to last 60 Seconds but more like 20 Hours or so!!!