Awesome... Its all working perfectly now! Makes perfect sense why the update
is like that.
> -----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
> ----- 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')
> > (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]