为什么执行mysql语句时values中已经换成对应的内容了？

Question

$sql="insert into test1(num1,name,sex,age,telephone,hospital,id,arear,bed,sample,num,doctor,data,dis,subobject,result) values('$str','$name','$sex','$age','$telephone','$hospital','$id','$area','$bed','$sample','$num','$doctor','$data','$dig','$object','$result')";$result=mysql_query($sql);if(!$result){echo "插入失败";}elseecho "插入成功";当代码是上面的执行就成功但是当代码变成下面的就不能执行了，只是多加了一个$add,print"$add";这句这行成功$sql="insert into test1(num1,name,sex,age,telephone,hospital,id,arear,bed,sample,num,doctor,data,dis,subobject,result,add) values('$str','$name','$sex','$age','$telephone','$hospital','$id','$area','$bed','$sample','$num','$doctor','$data','$dig','$object','$result','$add')";$result=mysql_query($sql);if(!$result){echo "插入失败";}elseecho "插入成功";而且在mysql中执行insert into test1(num1,name,sex,age,telephone,hospital,id,arear,bed,sample,num,doctor,data,dis,subobject,result) values('$str','$name','$sex','$age','$telephone','$hospital','$id','$area','$bed','$sample','$num','$doctor','$data','$dig','$object','$result');是正确的，可以插入但是执行insert into test1(num1,name,sex,age,telephone,hospital,id,arear,bed,sample,num,doctor,data,dis,subobject,result,add) values('$str','$name','$sex','$age','$telephone','$hospital','$id','$area','$bed','$sample','$num','$doctor','$data','$dig','$object','$result','$add');错误，不能执行。table名：test1表头包括：num1,name,sex,age,telephone,hospital,id,arear,bed,sample,num,doctor,data,dis,subobject,result,add执行mysql语句时values中已经换成对应的内容了。

Answer 1

if(!$result) {     echo "插入失败"; }      else   echo "插入成功";

改成

echo $result ? '插入成功' : '插入失败，Mysql错误是：' . mysql_error();

然后运行一下，如果出错，会有一段关于插入数据库失败的英文错误原因提示，根据这个提示，能很直观的知道失败的原因

Answer 2

可能跟你的add这一列的数据类型或者是长度有关，具体要看报何种类型错误