Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
- php mysql - time question
June 9, 2006, 11:14 am
rate this thread
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?