聊天室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 "";

           }



}





?>