คือรับค่ามาจากแอนดรอย แล้วเอาไปเช็คใน mssql แล้วก็เอามาโชว์ครับ

อันนี้ php ตัวเช็คหรือเอาไปเทียบหาค่าใน mssql ครับ
-------------------------------------------------------------------
<?php
    $host = "192.168.xxx.x" ; // Host ip
    $username = "name" ;   //  Username
    $password = "pass" ;   // Password
    $db = "xxxxxx" ;  // Database Name
    $objConnect = mssql_connect($host, $username, $password);
    $objDB = mssql_select_db("xxxxx");

    //$_POST["sUID"] = "17314";
    //$_POST["strUser"] = "weerachai@1";  // for Sample

    $strUID = $_POST["sUID"];
    $strSQL = "SELECT * FROM view_stocklist WHERE 1 AND  UID = '".$strUID."'   ";

    $objQuery = mssql_query($strSQL);
    $objResult = mssql_fetch_array($objQuery);
    $intNumRows = mssql_num_rows($objQuery);
    if($intNumRows==0)
    {
        $arr['StatusID'] = "0";
        $arr['UID'] = "0";
        $arr['Error'] = "No barcode  ";
    
    }
    else
    {
        $arr['StatusID'] = "1";
        $arr['UID'] = $objResult["UID"];
        $arr['Error...'] = "";    
    }

    /**
        $arr['StatusID'] // (0=Failed , 1=Complete)
        $arr['MemberID'] // MemberID
        $arr['Error' // Error Message
    */
    
    mssql_close($objConnect);
    
    echo json_encode($arr);
?>
-----------------------------------------
ส่วนอันนี้ ตัวget ค่ามาโชว์
-----------------------------------------

<?php
$host = "192.168.xxx.xx" ; // Host ip
$username = "xxxx" ;   //  Username
$password = "xxxxx" ;   // Password
$db = "xxxxxxx" ;  // Database Name
    $objConnect = mssql_connect($host, $username, $password);
    $objDB = mssql_select_db("xxxxxxx");
    
    $strUID = $_POST["sUID"];
    $strSQL = "SELECT * FROM view_stocklist WHERE  UID = '".$strUID."'  ";
    $objQuery = mssql_query($strSQL);
    $obResult = mssql_fetch_array($objQuery);
    if($obResult)
    {
        $arr["PARTNUMBER"] = $obResult["PARTNUMBER"];
        $arr["DESCRIPTN"] = $obResult["DESCRIPTN"];
        $arr["WHCODE"] = $obResult["WHCODE"];
        $arr["LOCATION"] = $obResult["LOCATION"];
        $arr["QTY"] = $obResult["QTY"];
        $arr["UM"] = $obResult["UM"];
        $arr["COND"] = $obResult["COND"];
    }
    //mysql_close($objConnect);
    
    echo json_encode($arr);
    
    ?>


----------------------

ช่วยดูทีครับควรเปลี่ยนตรงไหนพอดี มัน error แบบนี้ แต่มันไปเช็คถูก แต่ถ้าผมเอา WHERE 1 ออก ค่ามันไปเช็ค {"StatusID":"1","MemberID":null,"Error...":""} ตรง else แทน
---------------------------------------------------------------

Warning: mssql_query() [function.mssql-query]: message: An expression of non-boolean type specified in a context where a condition is expected, near 'AND'. (severity 15) in C:\AppServ\www\joyMssql.php on line 16

Warning: mssql_query() [function.mssql-query]: Query failed in C:\AppServ\www\joyMssql.php on line 16

Warning: mssql_fetch_array(): supplied argument is not a valid MS SQL-result resource in C:\AppServ\www\joyMssql.php on line 17

Warning: mssql_num_rows(): supplied argument is not a valid MS SQL-result resource in C:\AppServ\www\joyMssql.php on line 18
{"StatusID":"0","MemberID":"0","Error":"No barcode "}