Posted by lorento on 06/09/06 11:23

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

• Next in forum: Re: Return current page and variables: $PHP_SELF dose not do it.
• Prev in forum: Re: newbie: problem with mysql_fetch_array
• Thread view: Re: php mysql - time question

[Reply to this message]