Re: Help with SQL statement
| From: | .....hG | Date: | Fri, 18 Feb 2005 16:02:19 +0000 |
| Subject: | Re: Help with SQL statement | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-209034@lists.php.net to get a copy of this message | ||
Im a begininer at PHP but how about session?
--
...hG
http://www.helmutgranda.com
"Jacques" <admin@hrfocus.co.za> wrote in message
news:20050218052124.48438.qmail@lists.php.net...
: 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