刚写完一个插入数据库的程序,可是mysql却出现了怪病,语句如下:
$userid = $_SESSION[USERID];
$userip = $_SERVER['REMOTE_ADDR'];
$log_time = date("Y-m-d H:i:s");
$sql = "insert into login_log(userid,userip,state,log_time) values ('$userid','$userip','$result','$log_time')";
mysql_query($sql);
每执行一次操作,居然插入2条重复数据,有时是3条,请较高手是这么回事?
附表login_log结构:
CREATE TABLE `login_log` (
`lid` int(10) NOT NULL auto_increment,
`userid` int(10) NOT NULL,
`userip` varchar(15) NOT NULL,
`state` int(1) NOT NULL default '0',
`log_time` datetime NOT NULL,
PRIMARY KEY (`lid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=20 ;
$userid = $_SESSION[USERID];
$userip = $_SERVER['REMOTE_ADDR'];
$log_time = date("Y-m-d H:i:s");
$sql = "insert into login_log(userid,userip,state,log_time) values ('$userid','$userip','$result','$log_time')";
mysql_query($sql);
每执行一次操作,居然插入2条重复数据,有时是3条,请较高手是这么回事?
附表login_log结构:
CREATE TABLE `login_log` (
`lid` int(10) NOT NULL auto_increment,
`userid` int(10) NOT NULL,
`userip` varchar(15) NOT NULL,
`state` int(1) NOT NULL default '0',
`log_time` datetime NOT NULL,
PRIMARY KEY (`lid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=20 ;
[align=center]==== 思想重于技巧 ====
[/align]
.
贴子分数<20:对自已的问题不予重视。
贴子大量未结:对别人的回答不予尊重。
.