Awesome... Its all working perfectly now! Makes perfect sense why the update
is like that.

thanks again!

__________________
Jason Dulberg
Extreme MTB
http://extreme.nas.net



> -----Original Message-----
> From: Sheridan Saint-Michel [mailto:[EMAIL PROTECTED]]
> Sent: September 26, 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='',time_in=time_in WHERE
> (logged_in.userid='$aid') AND (logged_in.session='$sessid')";
>
> Sheridan Saint-Michel
> 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] select based on time/date
>
>
> > You were right! I changed it to a timestamp (14) and the selection is
> > working great now.
> >
> > Only problem is that when I logout which UPDATE's the table to clear the
> > $session field, the $time_in timestamp gets updated because of the NOW()
> > function. I need that date to stay the same when someone logs out.
> >
> > current logout.php:
> > $out = "UPDATE logged_in SET session='' WHERE (logged_in.userid='$aid')
> AND
> > (logged_in.session='$sessid')";
> >
> > Is there a way to only allow the NOW() to work when a row is
> added to the
> > table? Or perhaps another way....
> >
> > Thank you again for your time. I've learned alot from this.
> >
> > __________________
> > Jason Dulberg
> > Extreme MTB
> > http://extreme.nas.net


-- 
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]

Reply via email to