[SOLVED] Where datetime is recent?

[Azu]

I have some tables and there is a time field in them that is generated by now() and I want to select all of the data that are recent

 

select id from news where (date()-time)<60

That should select all of them that are less then 60 seconds old

 

But it never works, just returns false over and over no matter what doesn't even give me an error it just doesn't work.

 

Please tell me why it's not working and how I can fix it

[Barand]

WHERE date > NOW() - INTERVAL 60 seconds

[Azu]

Thanks