, 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 = mysql_query($sql);
If it will help, here's the table structure -- looks like my
of 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: [PHP] select based on time/date
I
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]
Subject: Re: [PHP] select based on time/date
The reason my query
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='',time_in=time_in WHERE
(logged_in.userid='$aid') AND (logged_in.session
-
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: [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
- 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 page and its a bit
easier to understand than
-
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 page and its a bit
easier to understand than the CONCATS.
Would I
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 tried
]
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 Dulberg [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 25, 2001 6:08 PM
To: Sheridan Saint-Michel; [EMAIL PROTECTED]
Subject
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
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
12 matches
Mail list logo