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]
