$sql="INSERT INTO `dingdan`
(`id`,`name`,`kh`,`cm`,`sl`,`ck`,`fbj`,`zk`,`yf`,`zhuangtai`,`dh`,`date`,`shname`,`tel`,`dz`,`yb`,`kd`)
VALUES( '$id','$user','$inkh','$incm','$insl','$inck','$infbj','10','$inzhuangtai','0000000','$date','$shname','$shtel','$dz','$yb','$fangshi')";
$inresult =mysql_query($sql,$con);if(!$inresult) echo mysql_errno();
else echo "OK1000000";
(`id`,`name`,`kh`,`cm`,`sl`,`ck`,`fbj`,`zk`,`yf`,`zhuangtai`,`dh`,`date`,`shname`,`tel`,`dz`,`yb`,`kd`)
VALUES( '$id','$user','$inkh','$incm','$insl','$inck','$infbj','10','$inzhuangtai','0000000','$date','$shname','$shtel','$dz','$yb','$fangshi')";
$inresult =mysql_query($sql,$con);if(!$inresult) echo mysql_errno();
else echo "OK1000000";
错在那?报什么错 echo $sql; 再把输出的结果贴上来
$sql="INSERT INTO `dingdan`
(`name`,`kh`,`cm`,`sl`,`ck`,`fbj`,`zk`,`yf`,`zhuangtai`,`dh`,`date`,`shname`,`tel`,`dz`,`yb`,`kd`)
VALUES('$user','$inkh','$incm','$insl','$inck','$infbj','10','$inzhuangtai','0000000','$date','$shname','$shtel','$dz','$yb','$fangshi')";$inresult =mysql_query($sql,$con);if(!$inresult) echo mysql_errno();
else echo "OK1000000";
你这样试一下,如果还是不行就把SQL语句先输出,贴出来,我们再看看。
$sql = <<<CODE
INSERT INTO `dingdan`
(`id`,`name`,`kh`,`cm`,`sl`,`ck`,`fbj`,`zk`,`yf`,`zhuangtai`,`dh`,`date`,`shname`,`tel`,`dz`,`yb`,`kd`)
VALUES
($id,$user,$inkh,$incm,$insl,$inck,$infbj,"10",$inzhuangtai,"0000000",$date,$shname,$shtel,$dz,$yb,$fangshi)
CODE;
$inresult =mysql_query($sql,$con);if(!$inresult){
echo mysql_errno();
}else{
echo "OK1000000";
}
?>
$shtel= $_POST["shtel"];
$dz= $_POST["dz"];
$yb= $_POST["yb"];
$fangshi= $_POST["fangshi"];
$kuaidi= $_POST["kuaidi"];
$user= $_POST["user"];
$gouwuid=$_POST["gouwuid"];
$date=date('Y-m-d H:i:s',strtotime('+12 hour'));
$id=strtotime("now");$con = mysql_connect("localhost","","");
if (!$con) die(`不能链接: ` . mysql_error());
mysql_select_db("xindong_data", $con);
mysql_query("SET NAMES gb2312");
$result = mysql_query("SELECT * FROM `gouwu` where `name`='$user' ");
if($result)
{
while($row = mysql_fetch_array($result))
{
$inid=$row["id"];
$inkh=$row["kh"];
$inck=$row["ck"];
$inname=$row["name"];
$incm=$row["cm"];
$indj=$row["dj"];
$inzk=$row["zk"];
$ingmj=$row["gmj"];
$inhj=$row["hj"];
$insl=$row["sl"];
$inzhuangtai=$row["zhuangtai"];
$infbj=$row["fbj"]; echo "OK";
$con = mysql_connect("localhost","","");
if (!$con) die(`不能链接: ` . mysql_error());
mysql_select_db("xindong_data", $con);
mysql_query("SET NAMES gb2312");
$sql="INSERT INTO `dingdan`
(`id`,`name`,`kh`,`cm`,`sl`,`ck`,`fbj`,`zk`,`yf`,`zhuangtai`,`dh`,`date`,`shname`,`tel`,`dz`,`yb`,`kd`)
VALUES( '$id','$user','$inkh','$incm','$insl','$inck','$infbj','10','$inzhuangtai','0000000','$date','$shname','$shtel','$dz','$yb','$fangshi')";
$inresult =mysql_query($sql,$con);if(!$inresult) echo mysql_errno();
else echo "OK1000000"; } //while
}//if有记录这是完整代码,ID原来是自编号,现在我改成TEXT型了,报错是1136,谢谢,请帮我看看
原来是报 1136 SQL换成这个格式 报 1064
OKINSERT INTO `dingdan` (`name`,`kh`,`cm`,`sl`,`ck`,`fbj`,`zk`,`yf`,`zhuangtai`,`dh`,`date`,`shname`,`tel`,`dz`,`yb`,`kd`) VALUES('admin','ABCD023-1','40','1','湖南','2009Q4','10','N','0000000','2010-10-18 10:47:41','4234','23423','23423','4234','yue')1136OKINSERT INTO `dingdan` (`name`,`kh`,`cm`,`sl`,`ck`,`fbj`,`zk`,`yf`,`zhuangtai`,`dh`,`date`,`shname`,`tel`,`dz`,`yb`,`kd`) VALUES('admin','AJME001-2','M','1','山东','2010Q3','10','N','0000000','2010-10-18 10:47:41','4234','23423','23423','4234','yue')1136OKINSERT INTO `dingdan` (`name`,`kh`,`cm`,`sl`,`ck`,`fbj`,`zk`,`yf`,`zhuangtai`,`dh`,`date`,`shname`,`tel`,`dz`,`yb`,`kd`) VALUES('admin','ABLE416-2','0','1','湖南','2010Q3','10','N','0000000','2010-10-18 10:47:41','4234','23423','23423','4234','yue')1136 ?>
echo sql
后输出这些内容OK,是前面的字符不用管 1136是报错信息