I'm relatively new to MySQL but "think" I am getting a grip on it.
However, I am seeing some strange behavior when I perform an update
command (through PHP). This following query not only results in the
sessionLastTime column updated but also another column sessionStartTime
(key, auto_increment).
$dateNow=date("YmdHis");
...
$query = "update sessions set sessionLastTime=".$dateNow." where
sessionPHPSessID='".$PHPSESSID."' limit 1";
mysql_query($query) or die(mysql_error());
Any idea why this would happen?
Pertinent system info
Mac OS X (10.1.3) on Dual 1 GHz G4 w 1.5 GB RAM
Apache 1.3.20
PHP 4.1.2
MySQL 3.23.39
Stuart Chalk, Ph.D.
Department of Natural Sciences Phone:904-620-2831
University of North Florida Fax:904-620-3885
4567 St. Johns Bluff Road S. "The Flow Analysis Database"
Jacksonville FL 32224 USA http://www.fia.unf.edu/
---------------------------------------------------------------------
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
