[SOLVED] php, select thats newer than 1 minute.

[lynxus]

Hi guys,

I have a db with a bunch of stuff in a table with timestamps.

ie: date = 2009-06-01 19:22:30

 

How do i do.

select * from table  where date NEWER than 1 minute;

 

So it only shows rows with timestamps newer than 1 minute old.

 

Any ideas?

 

Thanks

G

[Maq]

Try something like this:

 

SELECT * FROM table WHERE date > DATE_SUB(NOW(), INTERVAL '1' MINUTE);

[lynxus]

Awesome!

 

Works perfect.

 

Thanks

verymuch!!!!

 

-G