I am trying to combine these two queries with or's into a combine result. I know the OR queries work by themselves but don't show any results when combined. Does any one have any suggestions?
PHP Code:
$results= mysql_query("SELECT * FROM Schools (SELECT *FROM Schools WHERE Western=
'$westernDisicipline' OR English= '$englishDisicipline' OR Fences='$fencesDisicipline'
(SELECT * FROM Schools WHERE NCAA= '$NCAAtype' OR IHSA='$IHSAtype' OR OTHER= '$OTHERtype'))");