Easy question

[karimali831]

Hi,

 

With this query:

SELECT * FROM ".PREFIX."cup_matches WHERE clan1='$getteam' || clan2='$getteam' && (clan1 != '0' && clan2 != '0') && (clan1 != '2147483647' && clan2 != '2147483647')

 

or

SELECT * FROM ".PREFIX."cup_matches WHERE clan1='$getteam' || clan2='$getteam' && (clan1 != '0' && clan2 != '0') && (clan1 != '2147483647' || clan2 != '2147483647')

 

is still picks up records where clan2 = 2147483647 and I don't want it to. So do not select if clan1 = 2147483647 OR clan2 = 2147483647.

 

Thanks for help also.

 

[TeddyKiller]

|| is a PHP Operator for OR.

In MYSQL, it is OR.

[oni-kun]

2147483647 is the maximum allocatable signed integer, Why are you running into the problem of having the clan ID set as so? There seems to be deeper flaws in the root of your coding logic.

[TeddyKiller]

Both queries look the same, and both clan ID's look the same too..

[karimali831]

@ TeddyKiller: thanks got it and if you look closely, it's not.

 

@ oni-kun: if clanID is 2147483647 this means team on a tournament has been taken off so therefore I don't want it selected when I'm using this query to get all matches by clanID. It works.. so why does it matter?

[TeddyKiller]

Ah yeah. Slight difference at the end

[PFMaBiSmAd]

Should work -

SELECT * FROM ".PREFIX."cup_matches
WHERE (clan1='$getteam' OR clan2='$getteam')
AND clan1 != '0' AND clan2 != '0' AND clan1 != '2147483647' AND clan2 != '2147483647'

[ignace]

|| is a PHP Operator for OR.

In MYSQL, it is OR.

 

Are you sure? http://dev.mysql.com/doc/refman/5.5/en/non-typed-operators.html

[TeddyKiller]

Oh.. my mistake. Just never had seen it used before.