To fix the issue you can do I have an unassign button and I want to remove the person logged in from whichever column he is in because I have 2 columns and he may be in any of them. , Your delete statement is wrong. It must be:
mysql_query("delete from App where (App.Person1 '" . addslashes(strip_tags($_SESSION["user"])) . "' OR App.Person2 = '" . addslashes(strip_tags($_SESSION["user"])) . "') and App.ID = '" . addslashes(strip_tags($_SESSION["edit"])) . "'");
I wish did fix the issue. The main thread spawns > 1 threads, and each of them can call return with an error value. If this happens, it is meaningless for the other threads to continue, and so they should be canceled. , How to accomplish this?
I hope this helps you . To directly answer your question I think this is a clean way to get the results you want.
WHERE (EffectiveDate IS NULL AND (Change1 IS NOT NULL OR Change2 IS NOT NULL OR
Change3 IS NOT NULL))
OR (EffectiveDate IS NOT NULL AND (Change1 IS NULL AND Change2 IS NULL AND Change3 IS