SQLite Forum

Return boolean if item EXISTS in database
Login
Yes, I know. Thank you. However even using 0/1 instead of FALSE/TRUE, it never returns that the record is missing...

Maybe the syntax that I use to make the call to the db is incorrect?

    $EntryExistsBoolean = $db->query("SELECT EXISTS (SELECT 1 FROM myTable WHERE Company_ID = 'SmartCo')");

    if ($EntryExistsBoolean === 0) //FALSE
    {
        echo "Record does not exist"; //Never triggered!
    }
    else if ($EntryExistsBoolean === 1) //TRUE
    {
        echo "Item found in the database";
    }