SQLite Forum

Return boolean if item EXISTS in database
Login
$EntryExistsBoolean = $db->query("SELECT name FROM myTable WHERE EXISTS (SELECT name FROM myTable WHERE company=SmartCo");

    if ($EntryExistsBoolean === false)
        {
            echo "Item does not exist in the database";
        }
        else
        {
            echo "Item found in the database";
        }


Problem: no boolean is ever returned! What is the correct syntax?