2.
@王万锋,mysql_select_db()是用来选择数据库的而不是选择数据表,把参数改为
3.
@王万锋,mysql_select_db()是用来选择数据库的而不是选择数据表,把参数改为mysql_select_db("你的数据库", $conn); 即可
4.
@Louis 现在出现了:查询数据错误:Table 'u733388657_banm.guestbook' doesn't exist
5.
@王万锋,改为这个试试,mysql_select_db("u733388657_banm", $conn);
7.
@Louis 请问数据表要在哪个文件里创建啊?新手,刚学my 好多不懂。
8.
@王万锋,选择数据库就是这样了,至于还报错啥的,请确定你的数据表建立了
9.
@Louis 那这句mysql_query("CREATE DATABASE guestbook",$con)应该放在哪个文件里呢
10.
@王万锋,
<?php
$conn=@mysql_connect("数据库服务器","用户名","密码");
if (!$conn){
die("连接数据库失败:" . mysql_error());
}
mysql_select_db("数据库库名",$conn);
@mysql_query("set name 'ut-f8'");
$sql="create guestbook(
id mediumint(8) unsigned not null auto_increment,
time int(10) not null,
content text(10000) not null,
primary key(id)
)engine=myisam default charset=utf8 auto_increment=1";
if(mysql_query($sql)){
echo 'guestbook表单创建成功';
}else{
echo'guestbook表单创建失败'.mysql_error();
}
?>
11.
@Louis guestbook琛ㄥ崟鍒涘缓澶辫触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 'guestbook(id mediumint(8) unsigned not null auto_increment, time int(10) not nul' at line 1查询数据错误:Table 'u733388657_banm.guestbook' doesn't exist
12.
@王万锋,额,抱歉,$sql="create table guestbook(
id mediumint(8) unsigned not null auto_increment,
time int(10) not null,
content text( 10000) not null,
primary key(id)
)engine=myisam default charset=utf8 auto_increment=1";应该是这样的