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:[EMAIL PROTECTED]]
> Sent: marted́ 25 settembre 2001 5.47
> To: [EMAIL PROTECTED]
> 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.
--
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]
