我写了一段代码，目的就是想把从表单输过来的内容添加到数据库，然后再把数据库里的值全部在表格中显示出来，现在的问题是，旧内容能显示出来，但新的内容就是不能添加，下面是我的代码，请哪位高手帮忙看一下：
无标题文档
<?php
$host = "localhost";
$user = "dszphp";
$password = "dszphp";
$dbname = "pet";
$name =$_POST['name'];
$owner = $_POST['owner'];
$species = $_POST['species'];
$s_sex = $_POST['S_sex'];
$birth = $_POST['birth'];
$death = $_POST['death'];
mysql_connect("$host","$user","$password","$dbname") or die("没有连接到数据库服务器");
$db = mysql_select_db("$dbname") or die("没有连接到数据库");
$sql = "Insert into pet(name,owner,species,s_sex,birth,death) values ('$name','$owner','$species','$s_sex','$birth','$death')";
$query = mysql_db_query($dbname,$sql);
$sql= "select * from pet";
$query = mysql_db_query($dbname,$sql);
if ($query){
echo "
| name |
owner |
species |
s_sex |
birth |
death |
";
while ($r = mysql_fetch_array($query)){
$username = $r["name"];
$owner = $r["owner"];
$species = $r["species"];
$s_sex = $r["s_sex"];
$birth = $r["birth"];
$death = $r["death"];
echo "
| $username |
$owner |
$species |
$s_sex |
$birth |
$death |
";
}//while 循环结束
echo "
";
}else{
echo "no data.";
}
echo "";
include ('links.x');
?>
订阅该问题
悬赏分：20 - 2007年08月22日