2001 1:59 PM
> To: Jason Dulberg; [EMAIL PROTECTED]
> Subject: Re: [PHP] select based on time/date
>
>
> Timestamp only sets itself to Now() if it isn't explicitly set (or set to
> NULL). So try this:
>
> $out = "UPDATE logged_in SET session='',
Website Administrator
FoxJet, an ITW Company
www.foxjet.com
- Original Message -
From: "Jason Dulberg" <[EMAIL PROTECTED]>
To: "Sheridan Saint-Michel" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Wednesday, September 26, 2001 12:44 PM
Subject: RE: [PHP] sel
u again for your time. I've learned alot from this.
__
Jason Dulberg
Extreme MTB
http://extreme.nas.net
> -Original Message-
> From: Sheridan Saint-Michel [mailto:[EMAIL PROTECTED]]
> Sent: September 26, 2001 9:38 AM
> To: Jason Dulberg; [EMAIL PROTECTED]
&
f the date types.
Sheridan Saint-Michel
Website Administrator
FoxJet, an ITW Company
www.foxjet.com
- Original Message -
From: "Jason Dulberg" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, September 25, 2001 6:24 PM
Subject: RE
TECTED]>;
<[EMAIL PROTECTED]>
Sent: Tuesday, September 25, 2001 5:08 PM
Subject: RE: [PHP] select based on time/date
> I tried basically what you have but I got an error:
>
> $sql="select * from logged_in where time_in + interval 1 hour <= now()";
> $result
To: 'Jason Dulberg'; 'Sheridan Saint-Michel'; [EMAIL PROTECTED]
> Subject: RE: [PHP] select based on time/date
>
>
> select * from logged_in where date_add(time_in,interval 1 hour) <= now()
>
> -jack
>
> -Original Message-
> From: Jason Du
select * from logged_in where date_add(time_in,interval 1 hour) <= now()
-jack
-Original Message-
From: Jason Dulberg [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 25, 2001 6:08 PM
To: Sheridan Saint-Michel; [EMAIL PROTECTED]
Subject: RE: [PHP] select based on time/date
I tr
>
> select * from sessions where $timein + interval 1 hour <= now();
- Original Message -
From: "Jason Dulberg" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, September 25, 2001 2:35 PM
Subject: RE: [PHP] select based on time/date
- Original Message -
From: "Jason Dulberg" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, September 25, 2001 2:35 PM
Subject: RE: [PHP] select based on time/date
> I had a look at the DATE_FORMAT info on the mysql doc
> > 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
heers,
> 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
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. I
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 whe
13 matches
Mail list logo
