You might want to first find lastlength before running the update query.
- Original Message -
From: "Siim Einfeldt aka Itpunk" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, June 08, 2001 2:25 AM
Subject: dealing with datetime
>
> Hi,
>
>
Hi,
Just working here on a php-mysql project and came to a weird problem, See
this:
mysql_query("UPDATE trackvisits SET
hitcount=hitcount+1,refreshtime=now(),lastlength=now()-arrivetime WHERE
username='$visitor'");
Especially notice the lastlength=now()-arrivetime . Both lastlength and
arrivet
