Hello,I have a form that has some options for the user (e.x, color,size and price). For every one the user can select a specific value from a menu OR select ALL (e.x: COLOR : ALL,RED,BLUE,BLACK).Now, I have one SELECT query that looks similar to (SELECT * FROM TABLE WHERE COLOR='$COLOR' AND SIZE='$SIZE' AND PRICE='$PRICE':)BUT, if for one of the options, the user selects the value "ALL". This will effect the query and return null.Is there some thing in the query that i can change to ignore that specific option if the value is ALL ?The only in hand solution i can think of now is to make an IF s