[SOLVED] SQL help

[Aravinthan]

Hi guys,

 

I was wondering,

I have this MYSQL Select code:

SELECT * FROM `schedule`  WHERE `month` = '12 'AND `year`='2009' AND `home_team`='16' OR `away_team`='16' ORDER BY `day` ASC

 

It shows results from every month and every year...

 

Why is that? The only 2 thing that it takes into consideration is the home_team and away_team and the Order By....

[Julian]

Are `month` and `year` separate columns on your sql structure? or are you using a date column that contains the month and year?

[Aravinthan]

year and month are seperate colums

 

Here is the colums:

-id

-year

-month

-home_team

-away_team

and there is more

[Julian]

Have you tried using: SELECT DISTINCT  or GROUP BY?

[Aravinthan]

How can Group By be useful here?

[Aravinthan]

I need the whole table information,

There is some game results that I have to get in a while Loop(php)

[kickstart]

Hi

 

Problem is down to the precedence of AND and OR.

 

MySQL evaluates the ANDs first and then the OR. Use brackets to force the issue:-

 

SELECT *

FROM `schedule` 

WHERE `month` = '12 '

AND `year`='2009'

AND (`home_team`='16'

OR `away_team`='16' )

ORDER BY `day` ASC

 

All the best

 

Keith

[Aravinthan]

Oh wow thank you so much!!!!!