Question

php中MYSQL的update问题；

我用mysql_query("update `user` set cishu=cishu+1 and time='".date(Y-m-d h:m:s)."' where username='".$username."'");不能更心。但是分开这样写就行了：
mysql_query("update `user` set cishu=cishu+1 where username='".$username."'");
mysql_query("update `user` set time='".date("Y-m-d h:m:s")."' where username='".$username."'");
为啥啊 。，大虾指导~~~

Answer 1

把 and 改成 逗号“,”

cishu=cishu+1 , time=.....................

Answer 2

mysql_query("update `user` set cishu=cishu+1,time='".date(Y-m-d h:m:s)."' where username='".$username."'");

Answer 3

与楼上说的一样，将cishu=cishu+1 and time='".date(Y-m-d h:m:s)."'改为cishu=cishu+1 , time='".date(Y-m-d h:m:s)."'