Note that there are some explanatory texts on larger screens.

plurals
  1. USRobert
    primarykey
    data
    text
    plurals
    1. COI'm not sure I'm communicating it properly then. "Hello out there" contains "out there" so that would be true, but doesn't contain "there out" or "Hello there" (the "Hello there" sequence doesn't occur anywhere in "Hello out there" as the " out" is blocking). However, "Hello there" would pass both for the AND and OR condition (but it would be removed from the checking list via the AND)
      singulars
    2. COSorry, I added in the comment but didn't retrofit the first sections. basically, split the string on the space and then searching with ANDs. So Car and Phone both appear in the string "Car With Phone" so they'd pass. I'll edit the upper section as well, thanks.
      singulars
    3. COAgain, .NET so don't know the PHP equivalent, but in a pseudocode sort of way that looks like it would work (maybe add (or $row['emailAddress'] == "" in the no results check), but keep in mind that unless you need the other columns that are pulled back from your query, it might be a bit overkill on what you're pulling back. would it work if it were $result = mysql_query("SELECT address FROM users WHERE emailAddress='".$emailAddress."' AND username='".$username."'");? That way you don't have the extra data out there and you can just (assuming PHP syntax) "if ($result != "") {// you found data}"
      singulars
 

Querying!

 
Guidance

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload