弄了个网上的PHP新闻发布系统的代码，每个功能我都试了一遍，但不知道注册页面为何总是提示注册失败，求大神帮忙看看
这是注册页面的代码
<?php
error_reporting(E_ALL^E_NOTICE^E_WARNING);
session_start();
$_SESSION["page"]="register";
?>
<style type="text/css">
.title{font-family: verdana, tahoma, sans-serif;FONT-SIZE: 12px;font-weight:bold}
.grey{FONT-SIZE: 12px;color:#666666}
<!--
body {
background-image: url(images/bg.gif);
}
-->
</style>
<link type="text/css" rel="stylesheet" href="css/1.css">
<style type="text/css">
<!--
.STYLE1 {font-size: 14px}
-->
</style>
<title>用户注册</title><body>
<form method="post" action="result.php" onSubmit="return idcheck();">
<p> </p>
<p> </p>
<p> </p>
<table width="208" border="0" align="center" cellpadding="5" cellspacing="0">
<tr>
<td bgcolor="#F4F4F4" class="title"><div align="center" class="STYLE3 STYLE1">用户注册</div></td>
</tr>
<tr>
<td class="grey"><img src="images/warning.gif" width="16" height="16" align="absmiddle"> <strong>请按照提示输入信息</strong></td>
</tr>
<tr>
<td class="title">用户名（Username）</td>
</tr>
<tr>
<td><input name="name" type="text" class="username" size="30" id="name1"> </td>
</tr>
<tr>
<td></td>
</tr>
<tr>
<td class="title">密码（Password）</td>
</tr>
<tr>
<td><input name="pwd1" type="password" class="password" size="30" id="pwdone"></td>
</tr>
<tr>
<td class="title">重复密码（Again Password）</td>
</tr>
<tr>
<td><input name="pwd2" type="password" class="password" size="30" id="pwdtwo"></td>
</tr>
<tr>
<td class="title">E-mail</td>
</tr>
<tr>
<td><input name="mail" type="text" class="email" size="30" id="email" value="@"></td>
</tr>
<tr>
<td class="title">安全提问（question）</td>
</tr>
</tr>
<tr>
<span style="position:absolute; overflow:hidden"><td class="title">
<select id="questionid" name="questionid" tabindex="6" class="question" style="margin:-2px">
<option value="无安全提问">无安全提问</option>
<option value="母亲的名字">母亲的名字</option>
<option value="爷爷的名字">爷爷的名字</option>
<option value="父亲出生的城市">父亲出生的城市</option>
<option value="您其中一位老师的名字">您其中一位老师的名字</option>
<option value="您个人计算机的型号">您个人计算机的型号</option>
<option value="您最喜欢的餐馆名称">您最喜欢的餐馆名称</option>
<option value="驾驶执照的最后四位数字">驾驶执照的最后四位数字</option>
</select>
</td></span>
</tr>
<tr>
<td class="title"><input name="question" type="text" class="question" size="30" id="email"></td>
</tr>
<tr>
<td align="right"><input type="image" name="login" src="images/Register1.gif"><a href="login.php"><img src="images/return.gif" border="0"></a></td>
</tr>
</table>
</form>
<script>
function idcheck()
{
if(document.getElementById('name1').value=="")
{
alert('请填写用户名！');
return false;
}
else if(document.getElementById('pwdone').value=="")
{
alert('请填写密码！');
return false;
}
else if(document.getElementById('pwdone').value!=document.getElementById('pwdtwo').value)
{
alert('请填写一致的密码！');
return false;
}
else if(document.getElementById('email').value=="")
{
alert('请填写E-Mail！');
return false;
}
else
{
return true;
}
}
</script>
</body>
这是注册结果界面的代码
<?php
include("connect.php");
session_start();
?>
<style type="text/css">
.title{font-family: verdana, tahoma, sans-serif;FONT-SIZE: 12px;font-weight:bold}
<!--
body {
background-image: url(images/bg.gif);
}
a{text-decoration:none}
.p{cursor: hand}
-->
</style>
<form method="get">
<p> </p>
<p> </p>
<p> </p>
<table width="100%" border="0" class="title" align="center">
<tr>
<td></td>
</tr>
<tr>
<td align="center">
<?php
if($_SESSION["page"]=="login")
{
$sql="select count(*) from login where name='$_POST[name]' and pwd='$_POST[pwd]'";
$query=mysql_query($sql);
$row=mysql_fetch_array($query);
if($row[0]==1)
{
$_SESSION[username]=$_POST[name];
$_SESSION[aa]=1;
echo "欢迎您回来,{$_POST[name]}。现在将转入主页面。<br>";
echo "<a href=\"index.php\">如果您的浏览器没有自动跳转，请点击这里</a>";
echo "<script>window.setTimeout(\"location.href='index.php';\",3000)</script>";
}
else
{
echo "用户或密码错误，请单击<a href=\"register.php\" target=\"_top\"><img src=\"images/Register.gif\" border=\"0\" class=\"p\" /><br>";
}
}
else
if($_SESSION["page"]=="register")
{
$sql="select count(*) from login where name='$_POST[name]'";
$row=mysql_fetch_array(mysql_query($sql));
if($row[0]==1)
{
echo "用户名已存在！请单击<a href=\"register.php\" target=\"_top\"><img src=\"images/Register.gif\" border=\"0\" class=\"p\" /><br>";
}
else
{
$sql1="INSERT INTO `my`.`login` (`name` ,`pwd` ,`email` ,`question` ,`key` )VALUES ('$_POST[name]', '$_POST[pwd1]', '$_POST[mail]', '$_POST[questionid]', '$_POST[question]')";
if(mysql_query($sql1))
{
$_SESSION[username]=$_POST[name];
echo "注册成功！现在将转入主页面。<br>";
echo "<a href=\"index.php\">如果您的浏览器没有自动跳转，请点击这里</a>";
echo "<script>window.setTimeout(\"location.href='index.php';\",3000)</script>";
}
else
{
echo "注册失败！请单击<a href=\"register.php\" target=\"_top\"><img src=\"images/Register.gif\" border=\"0\" class=\"p\" /><br>";
}
}
}
elseif($_SESSION["page"]=="loadpwd")
{
$sql="SELECT count(*) FROM `login` WHERE `name`='$_GET[name]' and `key`='$_POST[question]'";
$row=mysql_fetch_array(mysql_query($sql));
if($row[0]==1)
{
$sql1="SELECT pwd FROM `login` WHERE `name`='$_GET[name]' and `key`='$_POST[question]'";
$row=mysql_fetch_array(mysql_query($sql1));
echo "你的密码为： $row[0] <br>请牢记！<br>返回登录页面请点击，<a href='login.php'>登陆</a>";
}
else
{
echo "问题回答错误！返回重新查询密码，请点击<a href='loadpwd1.php'>返回</a>";
}
}
?>
</td>
</tr>
<tr>
<td> </td>
</tr>
</table>
</form>
