$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中已經換成對應的內容了。
添加回答
舉報
0/150
提交
取消