<?php
    $db_host="localhost";
    $db_user="username_goes_here";
    $db_pass="password_goes_here";
    $connection = @mysql_connect($db_host,$db_user,$db_pass) or die("Error connecting to database");
    $db = mysql_select_db("abserve_wechat", $connection);

    $username = $_REQUEST['username'];
    $phonenumber = $_REQUEST['phonenumber'];
    $password = $_REQUEST['password'];
    $email = $_REQUEST['email'];
    $pass=md5($password);

    unset($_REQUEST['adminer_version']);
        //print_r($_REQUEST);exit;

        $result = mysql_query("SELECT * FROM `abserve_users`  WHERE `phonenumber`='$phonenumber'");
        if(mysql_num_rows($result) == 1)
        {
            $response['message']    = "phonenumber already taken";
            echo json_encode($response);exit;
        }else{
            $insert = mysql_query("INSERT INTO `abserve_users` (username,phonenumber,password,email) VALUES ('$username', '$phonenumber','$pass','$email')");

        $response['message']    = "Inserted  successfully";

        echo json_encode($response);exit;
        }
?>

$username = $_REQUEST['username'];
$phonenumber = $_REQUEST['phonenumber'];
$password = $_REQUEST['password'];
$email = $_REQUEST['email'];

Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /home/abservedemotech/public_html/projects/android/wechatapp‌​/wecant.php on line 18

php Desktoptest_stack.php

{"message":"Inserted  successfully"}

php Desktoptest_stack.php
{"message":"phonenumber already taken"}

$result = mysql_query("SELECT * FROM `abserve_users`  WHERE `phonenumber`='$phonenumber'");

$result = mysql_query("SELECT * FROM `abserve_users`  WHERE `phonenumber`='$phonenumber'") or die("query failed to execute");

$query = "SELECT * FROM `abserve_users`  WHERE `phonenumber`='$phonenumber'";
 $result = mysql_query($query) or checkerror($query);

function checkerror($query){


    echo "<div style='position:fixed;z-index:400;top:20%;border:5px solid red;width:600px;left:0;right:0;margin:auto;padding:20px;background:white;'>
    <h1>Sorry to disturb you !! But an error is found</h1>
     <p>The error is regarding the following query :</p>
     <p>".$query."</p>
    </div>";
    die();

}