Multiple Items in WHERE clause

[cmccomas]

Currently, I have the WHERE clause as:

$query = "SELECT * FROM wv_scores WHERE visitor  = '$team' OR home  = '$team' AND year = '$year' ORDER BY ID ASC";

The link I have is set to:

<a href="team.php?team=<? echo $row-> visitor ; ?>&year=<? echo $row->year; ?>"><? echo $row-> visitor ; ?></a>

So, if the team name is School and the year is 2005, the link is going to team.php?team=School&year=2005

Currently the visitor = OR home = works, but the OR clause doesn't work. What am I doing wrong?

[toplay]

I'm not sure if I understand you but it could be as simple as putting parenthesis like so:

$query = "SELECT * FROM wv_scores WHERE (visitor  = '$team' OR home  = '$team') AND year = '$year' ORDER BY ID ASC";