表我这边建不起来,出错 :( 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 'user( userid int( 8 ) PRIMARY KEY NOT NULL , username varc
to 早起:表我已经建好了,请参考http://expert.csdn.net/Expert/topic/2317/2317275.xml?temp=2.729434E-02
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 'user( userid int( 8 ) PRIMARY KEY NOT NULL , username varc
你把primary key 写在字段的后面:如下(试试看)
_______________________________________________________________ CREATE TABLE user( userid int(8) NOT NULL,
username varchar(16) ,
userpwd varchar(10) ,
useremail varchar(40) ,
zipcode int(6),
telnum varchar(13),
question varchar(40) ,
answer varchar(40), primary key (userid)) ;
________________________________________________________
如果这样不是不行,那就可能是你的query语句后面的insrt 语句有问题
————————————————————————————————————————————
对了我忘了说了:我以前也遇到过这样的问题一个insert语句让我和我的同学一起搞了将近三个小时才搞定,也是在没有办法的情况下,把phpmyadmin执行过后显示的语句给copy下来写php里面才起作用的。你可以试试
————————————————————————————————————
maxid() 提供的
INSERT INTO `user` ( `userid` , `username` , `userpwd` , `useremail` , `zipcode` , `telnum` , `question` , `answer` ) VALUES ( '', '".$newname."', '".$newpwd."', NULL , NULL , '".$telnum."', NULL , NULL ); "在输入用户名时,没有把双引号去掉,结果建立的用户名其实是 "我的用户名",呵呵,当然在登陆时显示出:没有这个用户名了。望广大同志引以为鉴!!明日午时结贴,up有分!