select-php, do you want to query the SQL that the registered mailbox already exists, as follows?

Selectmysqlphpsql

The problem is solved.

Key code:
Query mailboxes for Duplicates

     $user_email = $_POST["user_email"];    $sql = "select count(*) from users where user_email='$user_email'";    $result = mysql_query($sql,$con);    $row = mysql_fetch_row($result);    if ( $row[0] > 0)     {           echo $row[0];        echo "
邮箱已注册过，请直接登陆或找回密码";}     else {        //----增加新的用户--begin

--------Issue update-------
Use the following code, and then register, enter the database already exists mailbox, will still register successfully.
This is not normal, ask where the problem appears?
After my positioning, as if the "Query mailbox is duplicated" code does not take effect, please help to see?

 //查询邮箱是否重复    $user_email = $_POST["user_email"];    $sql = "select count(*) from users where user_email='$user_email'";    if (mysql_query($sql,$con)=='1')     {echo "exist";}     else {        //----增加新的用户--begin

     
   
    
       
   
   ' Echo ' Registration is successful! ".'

"Echo" Pleased to meet you, ". $_post[" User_nickname "]. '
';        $url = '/login.php '; echo "Click here to Login";//Disconnect database connection mysql_close ($con);} }//----Add new user--end} else echo "
:( Failed, please modify ~ ";? >

