日期:2014-05-17 浏览次数:20512 次
$result=mysql_query("select * from STUDENT where S_ID='$user'"); if (mysql_num_rows($result)>0) { echo "用户名已被使用,请更换"; echo "<script>window.location.href='index.php';</script>"; exit; //加上退出。否则用户名存在也会插入一条数据 } $in=mysql_query("insert into STUDENT values('$user','".md5(trim($userword))."','$name','$sex','$tel','$mail')"); if(mysql_affected_rows()) { echo "恭喜,注册成功"; echo "<script>window.location.href='index.php';</script>"; } else { echo "注册失败"; } mysql_close($db);
------解决方案--------------------
运行SQL语句:
ALTER TABLE `STUDENT` CHANGE `tel` `tel` VARCHAR(100);