[請益] insert一直出現錯誤訊息
我的insert寫的過程如下(以下兩種方法我都試過了)
-------------------------------------------------------------------
$sql1 = sprintf("insert into case(caseid,casename,casedetail)
values(null,'%s','%s')", $casename,$casedetail);
或
$sql1 = "INSERT INTO case (caseid,casename,casedetail)
VALUES (NULL, '$casename', '$casedetail')";
最後執行
$result1 = mysql_query($sql1) or die(mysql_error());
-------------------------------------------------------------------
caseid在資料庫有設定成autoicreament
$casename和$casedetail都是varchar
但在run的時候一直出現錯誤訊息(如下)
You have an error in your SQL syntax; check the manual that corresponds to
your MySQL server version for the right syntax to use near
'case(caseid,casename,casedetail) values(null,'sdv','dv')' at line 1
請問是哪個部分出錯了?
謝謝
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 140.115.230.171
※ 編輯: vSofav 來自: 140.115.230.171 (05/17 02:34)
推
05/17 08:14, , 1F
05/17 08:14, 1F
推
05/17 14:26, , 2F
05/17 14:26, 2F
推
05/17 15:45, , 3F
05/17 15:45, 3F
推
05/17 16:17, , 4F
05/17 16:17, 4F
推
05/17 21:59, , 5F
05/17 21:59, 5F