[SOLVED] Faster processing method?

[Q695]

Is there a faster way to process this statement:

$sql="SELECT * FROM players WHERE gloves='$item' AND id='$id' OR helmet='$item' AND id='$id' OR amulet='$item' AND id='$id' OR weapon='$item' AND id='$id' OR armor='$item' AND id='$id' OR shield='$item' AND id='$id' OR ring='$item' AND id='$id' OR boots='$item' AND id='$id' OR rune='$item' AND id='$id';";

[kickstart]

Hi

 

Bit cleaner:-

 

$sql="SELECT * 
FROM players 
WHERE (gloves='$item' 
OR helmet='$item' 
OR amulet='$item' 
OR weapon='$item' 
OR armor='$item' 
OR shield='$item' 
OR ring='$item' 
OR boots='$item' 
OR rune='$item')
AND id='$id';";

 

You coul also try:-

 

$sql="SELECT * 
FROM players 
WHERE '$item' IN (gloves, helmet, amulet, weapon, armor, shield, ring, boots, rune)
AND id='$id';";

 

All the best

 

Keith