[RESOLVED] I don't want these in my pants!

[Beffic]

So I have a database problem in mysql, and when I am trying to retrieve data from the database of a certain class and where the owner is me. But for some reason it is collecting all the items of that class and every owner.

Not sure how to fix it...

$Sell2="SELECT * FROM Inventory WHERE Owner='$Player' AND Class='ShortWeapon' OR Class='LongWeapon' OR Class='Helm' OR Class='Leggings' OR Class='Gauntlets' OR Class='Boots' OR Class='ChainMail' OR Class='PlateBody'";

[Bjom]

$Sell2="SELECT * 
FROM Inventory 
WHERE Owner='$Player' AND 
(Class='ShortWeapon' 
OR Class='LongWeapon' 
OR Class='Helm' 
OR Class='Leggings' 
OR Class='Gauntlets' 
OR Class='Boots' 
OR Class='ChainMail' 
OR Class='PlateBody')";

add the parentheses as above

[Beffic]

ahhhh..... amazing. Thanks

=)