php mysql - time question

[Nel]

Hi,

I am trying to access the records from a database for the last hours updates
using the following code.

SELECT * FROM `log` WHERE (
unix_timestamp(now() - 3600) < unix_timestamp(timevisited)
)

It doesn't seem to be working correctly. It returns all results (going back
a few hours to when I started the log table).

Am I making some basic mistake?

Nel.

[lorento]

Nel wrote:

SELECT * FROM `log` WHERE (
unix_timestamp(now() - 3600) < unix_timestamp(timevisited)
)

It must be :
SELECT * FROM `log` WHERE (
(unix_timestamp(now()) - 3600) < unix_timestamp(timevisited)
)

--
http://blog.deshot.com
http://www.groupvita.com

[Nel]

"lorento" <la**********@yahoo.com> wrote in message
news:11*********************@f6g2000cwb.googlegrou ps.com...

Nel wrote:

SELECT * FROM `log` WHERE (
unix_timestamp(now() - 3600) < unix_timestamp(timevisited)
)

It must be :
SELECT * FROM `log` WHERE (
(unix_timestamp(now()) - 3600) < unix_timestamp(timevisited)
)

--
http://blog.deshot.com
http://www.groupvita.com

Thanks Lorento :)

Nel