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
I had a look at the DATE_FORMAT info on the mysql doc page and its a bit
easier to understand than the CONCATS.
Would I want to use the CURTIME() function since I would want to select
sessions based on the hour? How would I go about combining CURTIME with the
rest of my query?
Theoretically, her
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
> t
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.: -00-00. With that string you should be
able to do
12 matches
Mail list logo
