聊天室php&mysql(五)

第五个页面name="changenick.php"

<?
include "../signup/mysql.php";
//echo $userid;
if($action=="ok")
{
$sql="select * from chat_user_list where userid='$nick'";
$result=mysql_query($sql) or die(mysql_error());
if(!$result) echo "该呢称已被他人占用 请重新填写";
else
{
$sql="update chat_user_list set id='$nick',passwd='$passwd',sex='$sex' where userid='$userid'";
$result=mysql_query($sql)or die(mysql_error());

$sql="update chat_user set id='$nick',passwd='$passwd',sex='$sex' where userid='$userid'";
$result=mysql_query($sql)or die(mysql_error());
}
if($result){
echo "";
}

}

?>