title: SQL: Handling multiple SELECT conditions?
body: <p>I'm just an basic SQL user (mySQL+php now). I have search box with multiple input (conditions). </p>
  
  <p>For example:</p>
  
  <p>Color: <strong><em>_</em>___<em></strong><br>
  Size: <strong></em>__<em>_</em>_</strong><br>
  Price: <strong><em>_</em>__<em></strong><br>
  Condition: <strong></em>__<em>_</em></strong><br>
  Discount %: <strong><em>_</em>__<em></strong><br>
  Hit Count: <strong></em>__<em>_</em></strong><br>
  etc, many more ............</p>
  
  <p>User may input 1 or more fileds.<br>
  Result should be filtered for multiple input also.<br>
  So, how can i handle this multiple conditions in Query?</p>
  
  <p>I'm confusing how to write query (in former way):<br>
  <code>SELECT * FROM _item_ WHERE color='silver' AND/OR .... ... ?????</code>
  ????</p>
  
  <p>A simple sample please.</p>