trying to get this query to work

[NZ_Kiwis]

$result = mysql_query ("SELECT * from results_data where (team1_id or team2_id) = $Team_ID");

it does not work and when i remove the ( and ) it lists everything.. what's wrong.. the $Team_ID could be in one of two rows you see!!

[devinemke]

SELECT * FROM results_data WHERE team1_id = $Team_ID OR team2_id = $Team_ID

or

SELECT * FROM results_data WHERE $Team_ID IN(team1_id,team2_id)