Selecting a row by either field in MySQL

[NZ_Kiwis]

I have this code which works well, it lists all the results. but in results_data i have team1 and team2 feilds. I want to add a code to this so that if either team1 or team are = to say $teamsetid then it will show the row but no others. How can this be done???

$result = mysql_query ("select * from results_data where group_id = $latest_group_id and comp_run_id = $compid order by list_order");

[bogu]

U want to extract only the rows thathave team1=team2 for the same id?

U can do this like this ....

SELECT * FROM table t
WHERE t.team1=t.team2