select based on time/date
| From: | Jason Dulberg | Date: | Tue, 25 Sep 2001 03:47:02 +0000 |
| Subject: | select based on time/date | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-68639@lists.php.net to get a copy of this message | ||
I am using sessions on my site and have noticed that people often don't
click the "logout" button -- something which I need them to do in order to
clear their session from the db and update some site stats. In the sessions
table, I have a field $timein (in format F j, Y, g:i a) that gets added when
the user logs in and a $timeout field that gets added when they hit
"logout".
Basically, what I've been thinking of doing is using cron to run a php
script every hour or so that will search the table for sessions with no
$timeout field and $timein is more than X number of minutes old.
My problem is that since I'm using the F j, Y, g:i a date/time format, how
would I make the mysql select? Do I have to explode the $timein field?
Any suggestions are appreciated.
__________________
Jason Dulberg
Extreme MTB
http://extreme.nas.net