PHP Code:

$matches = mysql_query("SELECT * FROM `manager__******` WHERE `home_team` = '16' OR `away_team` = '16' AND `season` = '7' ORDER BY `day` ASC LIMIT 1"); 


Whenever i run this query on the database i receive results that i shouldnt.

I shouldn't receive any results at all because both results in the database have a season value of 6. But for some reason it pulls the result where `home_team` = 16.

Database:

home_team away_team season
Row 1: 16 20 6
Row 2: 20 16 6

Results Using Query

Row1: 16 20 6

'16' is a STRING value that will not be equal to the numeric value of 16

Try adding paranthesis (don't know how to spell that :P) around the two home team compares.

SELECT * FROM table WHERE (team1 = 16 OR team2 = 16) AND season = 6

In your case, without the (), MySQL runs this query

SELECT * FROM table WHERE team1 = 16 OR (team2 = 16 AND season = 6)

Kudos to Mattias, I was going to point that.
I even got burned by that very case today (duh...)

Chris, in those cases, mysql does an implicit cast from varchar to int, so it should not be a problem.
Just unnecessary work by the server.

cheers guys i tried using " necause the variables are selected using a $_SESSION but this didnt work, as soon it went into brackets ( ) it worked.

Originally Posted by tripy

Kudos to Mattias,

Absolutely.

Originally Posted by tripy

Chris, in those cases, mysql does an implicit cast from varchar to int, so it should not be a problem.
Just unnecessary work by the server.

True,

Although I have had occasional "issues" with this so I prefer not to rely on the casting.