RE: [PHP] select based on time/date

Don't do it with PHP. Instead use the native functions of mySQL itself. Use the combination of CONCAT(), some string and date functions of mySQL. Something like CONCAT(SUBSTRING(), SUBSTRING(), ...) so you end up in the right time format i.e.: 0000-00-00. With that string you should be able to do time comparisons within mySQL database. In other words, go to mySQL documentation and read there. mySQL will do it way better and faster than PHP. Cheers, Maxim Maletsky PHPBeginner.com -----Original Message----- From: Jason Dulberg [mailto:jdulberg@nas.net] Sent: martedì 25 settembre 2001 5.47 To: php-general@lists.php.net Subject: [PHP] select based on time/date 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: php-general-unsubscribe@lists.php.net For additional commands, e-mail: php-general-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net