我在php中做更新纪录的动作
根据print出来的sql语法如下
update `tableS` set `history`='[{"time":"2016-07-14
18:24:22","count":0,"link":"http://aaa.bbb.cc"}]' where account='110101'
只是我的资料表history字段里面的资料，却变成了这样
[{"time":"2016-07-14
18:24:22","count":0,"link":"http://aaa.bbb.cc"},
{"time":"2016-07-14
18:24:22","count":0,"link":"http://aaa.bbb.cc"},
{"time":"2016-07-14
18:24:22","count":0,"link":"http://aaa.bbb.cc"},
{"time":"2016-07-14
18:24:22","count":0,"link":"http://aaa.bbb.cc"}]
多出了3笔同样的纪录
想请问一下各位大大这种状况是因为什么呢
程式码如下，
[code]
$count=0;
$bitStr="1101010101111010";
while($count<30 && strlen($bitStr)>0){
$percent=0.1;
$obj=new stdClass();
$obj->time=$checkDate;
$obj->count=$count*$percent;
$obj->link=$url;
$arr=array();
array_push($arr,$obj);
$str=json_encode($arr);
$sql="update tableS set history='".$str."' where account='".$bitStr."'";
echo $sql;
mysql_query($sql);
$count++;
$bitStr=substr($bitStr,0,-1);
}
[/code]