select based on time/date

From: 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

« previous php.general (#68639) next »