注册 登录
编程论坛 PHP技术论坛

PHP建表请教错误

woa 发布于 2010-05-06 09:02, 744 次点击

<?php
$host="localhost";
$user="admin";
$password="abcde";
$db_name="info";
$table_name="User";
$conn=mysql_connect($host,$user,$password);
 if(!$conn)
{
  die ("".mysql_error());
}
  else
{
 echo "mysql host:$host,mysql user:$user<br>";
}

mysql_select_db($db_name,$conn) or
 die("select db error".mysql_error());
echo "db:$db_name table:$table_name<br>";

mysql_query("SET NAME'GB2312'");


$mysql_command="create table".$table_name."(name varchar(16),password(16))";


$result=mysql_query($mysql_command) or
      die("create table error".mysql_error());
echo "create table successed:$table_name";
?>
运行后,建表错误,可是看了半天也没发现语法哪错了,请教!!!
mysql host:localhost,mysql user:admin
db:info table:User
create table errorYou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'tableUserInfo(name varchar(16),password(16))' at line 1
1 回复
#2
Johnsylm2010-08-01 18:16
$mysql_command="create table".$table_name."(name varchar(16),password(16))";
name 的类型是 varchar ,长度限制为 15 ,难道说是我孤陋寡闻尚未风闻最近出了个 “password”的新类型?就算是有这个新类型你的字段名写了吗 - - 。。。,
应该是 password varchar(16) 吧 - - 。。。
1