Re: select based on time/date

On Tue, 25 Sep 2001 13:38, Maxim Maletsky \(PHPBeginner.com\) wrote: > 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 And, as someone recently pointed out in response to a similar suggestion I made, there is a mysql DATE_FORMAT function that will do the same thing without the CONCATS. -- David Robley Techno-JoaT, Web Maintainer, Mail List Admin, etc CENTRE FOR INJURY STUDIES Flinders University, SOUTH AUSTRALIA For every vision there is an equal and opposite revision.