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
arrivetime are datetime fields, so at least in theory this query should
update the lastlength field and set it to the right value
(=now()-arrivetime), but it actually just sets the lastlength value to
0000-00-00 00:00:00 . The arrivetime does have just a bit smaller value
than now(), at least some minutes.
Any idea why this might not work?
Thanks
Siim EInfeldt
Itpunk music Web
www.itmusicweb.co.uk
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
