I am trying to let to check the a table if there exists a value and if there exists a value it should output as JSON "one" and if it doesn't exist it should output "two". My thought is that With my SELECT EXIST Statement it should only return a row if there exists the value in the table but for some reason it always outputs a row.

Here is the code:

```
// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}
if ($result = mysqli_query($conn, $query)) {

    $newArr = array();
    $value = mysqli_fetch_object($result);
    $newArr[] = (bool) $value->item_exists;

    echo json_encode($newArr); // get all products in json format.    
}
*/

/* part where output is just 1 or 0*/
$query = "SELECT EXISTS(SELECT * FROM wp_woocommerce_order_items WHERE order_id = $sdata)";
$myArray = array();
if ($result = mysqli_query($conn, $query)) {
    while($row = $result->fetch_row()) {
            $myArray[] = $row;
    }
    // 2nd operation checkif order available
 if ($conn->affected_rows == 1) {
    echo json_encode($one);
 } else {
    //Success and return new id
    echo json_encode($two);
 }    
    //end 2nd operation
    echo json_encode($myArray);
}$result->close();
    echo json_encode($newArr); // get all products in json format.    
}
    $conn->close();
?>

```