Help with SQL statement
| From: | Jacques | Date: | Fri, 18 Feb 2005 05:21:13 +0000 |
| Subject: | Help with SQL statement | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-208989@lists.php.net to get a copy of this message | ||
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