date_add(time_in,interval 1 hour)
is the same as
time_in + interval 1 hour
as of MySQL 3.23 so unless you are using 3.22 you should get the
same result (anything prior to 3.22 won't support date_add)
Neither query is going to work, however, because time_in is a varchar
rather than one 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 plugged your query in and it didn't result in an error - however, it
came
> up with no results even though there should be.
>
> This one should have come up but didn't:
> INSERT INTO logged_in VALUES ( '5', 'b406e68a7cde49534a14f5fd8848006e',
> 'September 24, 2001, 3:27 pm', '');
> -- the fields correspond to the table structure quoted below
>
> Thanks again!
> __________________
> Jason Dulberg
> Extreme MTB
> http://extreme.nas.net
>
>
> > -----Original Message-----
> > From: Jack Dempsey [mailto:[EMAIL PROTECTED]]
> > Sent: September 25, 2001 7:07 PM
> > 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 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 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 structure
> > is
> > bit different from what I orignally posted:
> >
> > CREATE TABLE logged_in (
> > id tinyint(4) DEFAULT '0' NOT NULL auto_increment,
> > session varchar(100) DEFAULT '0' NOT NULL,
> > time_in varchar(50) NOT NULL,
> > KEY id (id)
> > );
>
>
> --
> 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]
--
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]
