聊天室php&mysql(五)

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 "";

}

}

?>