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!!!
Please ignore this Question.
I found the answer to it already.
what was it? because that sql looks okay to me