Column count doesn't match value count at row 1
打开提示,弄了一个注册页面,注册成功后将注册页面信息添加到数据库,提交注册时候显示Column count doesn't match value count at row 1求救!!
我的数据库
UE_ID int(11)
UE_img varchar(60)
UE_account varchar(60)
UE_accName varchar(60)
sfjl int(15)
zcr varchar(60)
UE_Faccount varchar(30)
UE_verMail varchar(60)
UE_check smallint(1)
UE_actiCode varchar(10)
UE_password varchar(80)
UE_question varchar(250)
UE_question2 varchar(255)
UE_question3 varchar(255)
UE_answer varchar(100)
UE_answer3 varchar(100)
UE_answer2 varchar(100)
UE_regTime datetime ...
UE_regIP varchar(60)
UE_nowTime text
UE_nowIP varchar(60)
UE_lastTime text
UE_lastIP varchar(60)
UE_logNum int(11)
UE_status smallint(1)
UE_level smallint(1)
UE_note text
UE_integral decimal(15,0)
UE_money decimal(15,0)
UE_sum float(11,0)
UE_info text
UE_secpwd varchar(80)
UE_theme varchar(60)
UE_tjx varchar(60)
UE_ldx varchar(60)
UE_mailCheck varchar(30)
UE_sfz varchar(20)
UE_qq varchar(20)
UE_phone varchar(20)
UE_truename varchar(60)
UE_activeTime text
UE_stop tinyint(2)
UE_toActive tinyint(2)
UE_drpd varchar(60)
zbqx int(5)
zbzh varchar(60)
ybhe decimal(15,4)
zsbhe decimal(15,4)
email varchar(60)
jihuouser varchar(60)
btbdz varchar(60)
pin varchar(255)
mz varchar(255)
xin varchar(255)
weixin varchar(255)
我的注册页面代码:
<?php
require_once ('config.php');
?>
<?php
if($_POST["submit"]){
if(empty($_POST['UE_account']))
echo "<script>alert('帐号不能为空');location='?tj=register';</script>";
else if(empty($_POST['UE_password']))
echo "<script>alert('密码不能为空');location='?tj=register';</script>";
else if($_POST['UE_password']!=$_POST['pass'])
echo "<script>alert('两次密码不一样');location='?tj=register';</script>";
else{
$_SESSION['ot_user']=$_POST['UE_account'];
$sql="insert into ot_user values('','".$_POST['UE_account']."','".md5($_POST['UE_password'])."','".$_POST['zhxm']."','".$_POST['UE_accName']."','".$_POST['weixin']."','".$_POST['UE_phone']."','".$_POST['zfb']."')";
$result=mysql_query($sql)or die(mysql_error());
if($result)
echo "<script>alert('恭喜你注册成功,马上进入主页面');location='member.php';</script>";
else
{
echo "<script>alert('注册失败');location='index.php';</script>";
mysql_close();
}
}
}
?>
</head>
<body>
<?php if($_GET['tj'] == 'register'){ ?>
<form id="theForm" name="theForm" method="post" action="" onSubmit="return chk(this)" runat="server" style="margin-bottom:0px;">
<table width="350" border="0" align="center" cellpadding="5" cellspacing="1" bgcolor="#B3B3B3">
<tr>
<td colspan="2" align="center" bgcolor="#EBEBEB">会员注册 以下打“*”为必填项</td>
</tr>
<tr>
<td width="60" align="right" bgcolor="#FFFFFF">账 号:</td>
<td width="317" bgcolor="#FFFFFF"><input name="UE_account" type="text" id="UE_account" size="20" maxlength="20" />
<font color="#FF0000"> *</font>(由数字或字母组成)</td>
</tr>
<tr>
<td align="right" bgcolor="#FFFFFF">密 码:</td>
<td bgcolor="#FFFFFF"><input name="UE_password" type="password" id="UE_password" size="20" maxlength="20" />
<font color="#FF0000"> *</font>(由数字或字母组成)</td>
</tr>
<tr>
<td align="right" bgcolor="#FFFFFF">确认密码:</td>
<td bgcolor="#FFFFFF"><input name="pass" type="password" id="pass" size="20" />
<font color="#FF0000"> *</font>(再次输入密码)</td>
</tr>
<tr>
<td align="right" bgcolor="#FFFFFF">真实姓名:</td>
<td bgcolor="#FFFFFF"><input name="zhxm" type="text" id="zhxm" size="20" />
<label><font color="#FF0000">*</font></label></td>
</tr>
<tr>
<td align="right" bgcolor="#FFFFFF">推荐人:</td>
<td align="left" bgcolor="#FFFFFF">
<input name="UE_accName" type="text" id="UE_accName" size="20"/></td>
</tr>
<tr>
<td align="right" bgcolor="#FFFFFF">微信号:</td>
<td bgcolor="#FFFFFF"><input name="weixin" type="text" id="weixin" size="20"/></td>
</tr>
<tr>
<td align="right" bgcolor="#FFFFFF">手机号码:</td>
<td bgcolor="#FFFFFF"><input name="UE_phone" type="text" id="UE_phone" size="20"/></td>
</tr>
<tr>
<td align="right" bgcolor="#FFFFFF">电子邮箱:</td>
<td bgcolor="#FFFFFF"><input name="zfb" type="text" id="zfb" size="20"/></td>
</tr>
<tr>
<td colspan="2" align="center" bgcolor="#FFFFFF"><input type="reset" name="button" id="button" value="重置表单" />
<input type="submit" name="submit" id="submit" value="确定注册" /></td>
</tr>
</table>
</form>
<?php } ?>
</body>
</html>