看板 PHP 關於我們 聯絡資訊
我在資料庫建立一個susers的table ============================================= CREATE TABLE `susers` ( `id` int(11) NOT NULL auto_increment, `tname` varchar(25) character set utf8 NOT NULL default '', `tsex` int(11) NOT NULL default '0', `tnumber` varchar(25) character set utf8 NOT NULL default '', `tbirthday` date NOT NULL default '0000-00-00', `tcountry` varchar(25) character set utf8 NOT NULL default '', `tschool` varchar(25) character set utf8 NOT NULL default '', `tjob` varchar(25) character set utf8 NOT NULL default '', `tteach1` varchar(25) character set utf8 NOT NULL default '', `tteach2` varchar(25) character set utf8 NOT NULL default '', `tphone` varchar(25) character set utf8 NOT NULL default '', `tpasswd` varchar(10) character set utf8 NOT NULL default '', `temail` varchar(25) character set utf8 NOT NULL default '', `tgid` varchar(25) character set utf8 NOT NULL default '1', PRIMARY KEY (`id`) ) ENGINE=MyISAM; =============================================================== 但是我在phpadmin下 以下的指令 一直出現錯誤,實在不太曉得自己的問題在哪 可否請各位高手指點 感激<(_ _)> INSERT INTO susers ('tname','tsex','tnumber','tbirthday','tcountry' ,'tschool','tjob','tteach1','tteach2','tphone','tpasswd','temail') VALUES ('aaa',1,'42042','1958-12-12','aaa','aaa','aaa','aaa','aaa','147', '$md5pass','$_POST[email]') 錯誤訊息 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 ''tname','tsex','tnumber','tbirthday','tcountry' ,'tschool','tjob','tteach1','tte' at line 2 -- ※ 發信站: 批踢踢實業坊(ptt.cc) ◆ From: 118.169.197.17
cbolong :記得欄位不用'' 03/24 02:44
buganini :欄位用` 03/24 03:25
cbolong :insert into susers (tname,tsex,tnumber......... 03/24 03:50
cbolong :我沒加'' 03/24 03:50
buganini :遇到關鍵字才會爆 03/24 04:27
PHP5 :'tname' ==> `tname` 03/24 21:23
PHP5 :'$_POST[email]' ===> '{$_POST['email']}' 03/24 21:24