Or MySQL

[kiwis]

$result2 = mysql_query ("SELECT * From FULL_MATCH_HEADER WHERE TEAM1_ID = '$ClubID' OR TEAM2_ID = $ClubID AND SEASON_ID = '163' AND MATCH_GROUP_ID = $GID");

I want to do a query but when Team1ID or Team2ID is = to $ClubID

this code works but when i but this or state in the where clause it doesn't...

[NogDog]

You probably want parentheses around the two comparisons with the "or" operator.

$result2 = mysql_query ("
SELECT * From FULL_MATCH_HEADER 
WHERE 
   (TEAM1_ID = '$ClubID' OR TEAM2_ID = $ClubID) 
   AND SEASON_ID = '163' 
   AND MATCH_GROUP_ID = $GID
");