作者ocst (new student)
看板PHP
標題[請益] 有關insert的問題
時間Tue Mar 24 02:36:02 2009
我在資料庫建立一個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