用php建表的问题

下面这段代码是在TEST数据库里建立一个REGUSER的表,用PHPMYADMIN没问题,可是用这段代码保存为PHP时就不行了 老是出错,那位大哥费点心帮忙看一下 谢谢

\n"; exit; } else { // Inform user of success print "# Database selected successfully ```
``` \n"; } $sql1="CREATE TABLE reguser ( id int(11) not null AUTO_INCREMENT, userid char(20) not null default '', sex char(2) not null default '', age smallint(6) not null default '', tel char(20)) not null default '', email char(50) not null default '', address char(10) not null default '', PRIMARY KEY (id) ) "; if (mysql_query($sql1)=="1") { echo " ```

数据库初始化...............成功

``` ```
``` "; } else { echo " ```

数据库初始化...............失败

``` ```
``` "; exit; } \--------------------------------------------------------------- 问题是挺奇怪。首先指出一点错误: if (mysql_query($sql1)=="1") mysql返回值是个整数,不一定是1。如果query查询符是update,insert,delete返回值可能是true或false 继续找错中ing
Published At
Categories with 数据库类
comments powered by Disqus