AND OR in same query.

[u214]

I'm trying to get the following query to work:

 

SELECT * FROM `Bans` WHERE (`BannedIP` = 76 AND `BannedSerial` = '4208394871238478ffbb13434') OR `BannedName` = 'Test'

--

So as you can see, I want if the BannedIP = 76 AND BannedSerial = 4208394871238478ffbb13434 OR BannedName = Test it will return a row

The reason why I'm doing this is because the serial is not unique and having the part of ip and serial together will reduce the chances of someone getting wrongfully banned.

 

In PHP, it would look something like:

if(($IP=76 && BannedSerial='serial') || BannedName='Test')

 

 

Note: BannedSerial is made up for this example; BannedIP = first 2 digits of an ip.

 

 

EDIT: I tested it with my name and it only works after the OR BannedName = 'myrealname'. So the thing that's messed up is this: (`BannedIP` = 76 AND `BannedSerial` = '4208394871238478ffbb13434')

[Muddy_Funster]

what's the chances on a sample dataset from your table?

[The Little Guy]

have you check the database to see if the values for BandIP and BandSerial even exist?