[RESOLVED] SELECT * FROM `db` WHERE `id`='1' returns TWO results...

[php-phan]

here is the full query

SELECT * FROM `S2`.`conversations` WHERE `id`='113' AND `to`='1' OR `from`='1'

But it returns all results where TO AND FROM =1
This is driving me nuts!

Do you know why?

[Shrike]

You get two because of the way the WHERE clauses get evaluated - the last two are not independent of the first. So stick the last two in parentheses

WHERE ... AND ( ... OR ... )

[php-phan]

OMG! THANK YOU SOOO MUCH. Its weird cause it worked forever and then all of a sudden today it started breaking...thanks you though! Now i can go to bed comfortably lol