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
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
