quick date problem

[interactive]

hey all how would i make sure its been atleast 20 seconds from a date that i pull out of a db (can be nay format dont matter to me) i know how to make sure its been exactly 20 secodns (lol i tihink thats pretty ez) but how do i make sure its atleast 20 seconds? thanks and all help is appreciated...

[mmilano]

if you are using mysql as your db, then query the date like this:

select * from table where date > (NOW() - 20)

[dannys]

Originally posted by mmilano
if you are using mysql as your db, then query the date like this:

select * from table where date > (NOW() - 20)

Won't that get posts that are uptop 20 seconds old, rather than at least 20 seconds?

SELECT * FROM table WHERE date < (NOW() - 20)

That would get all rows where the date is at least 20 seconds ago.