Posted by Jacques on 02/18/05 07:21
How can I determine which users have signed in and are still on-line during
the first minute after they have signed in? My sql statement currently
reads:
SELECT * FROM tblusers WHERE usignedin = "yes" AND utimesignedin = (time() -
60)
Hoe does one indicate seconds in a SQL statement? Can I use the time()
function or should I use the now() function rather?
Thanks
Jacques
Navigation:
[Reply to this message]
|