title: i want to search filter my database values using checkboxes php mysql
body: <p><a href="https://i.stack.imgur.com/D2ihD.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/D2ihD.png" alt="enter image description here"></a>by using this code i can now fetch pro_price table but i need multiple column saerch. this is my working code for an solo column, but i need to fetch two column more from that table. How i can i do that. please help</p>
  
  <p>Database name: <strong>auction</strong></p>
  
  <p>Table name : <strong>addproduct</strong></p>
  
  <p>Column names : <strong>pro_price, pro_code, hsn_code</strong></p>
  
  <p>This is my code,</p>
  
  <pre><code>if(isset($_REQUEST['search'])){
  $pro_price = $_REQUEST['pro_price'];
  foreach ($_REQUEST['pro_price'] as $pro_price) {
      $statearray[] = mysql_real_escape_string($pro_price);
  }
  $states = implode ("','", $statearray);
  $sql = "SELECT * FROM addproduct WHERE pro_price IN ('$states'))";
  $result = mysql_query($sql) or die(mysql_error());
  if (mysql_num_rows($result) == 0)
  {
      echo "Sorry, but we can not find an entry to match your query...&lt;br&gt;&lt;br&gt;";
  }
  else
  {
      echo "&lt;table border='1' width='900' class='srchrslt'&gt;
      &lt;tr class='head'&gt;
      &lt;td&gt;pro_name&lt;/td&gt;
      &lt;td&gt;pro_brand&lt;/td&gt;
      &lt;td&gt;hsn_code&lt;/td&gt;
      &lt;td&gt;pro_tax2&lt;/td&gt;
      &lt;td&gt;pro_tax3&lt;/td&gt;
      &lt;/tr&gt;";
      while($row = mysql_fetch_assoc( $result ))
      {              
          echo "&lt;tr&gt;";
  
          echo "&lt;td&gt;" . $row['pro_name'] . " &lt;/td&gt;";
          echo "&lt;td&gt;" . $row['pro_brand'] . " &lt;/td&gt;";
          echo "&lt;td&gt;" . $row['hsn_code'] . " &lt;/td&gt;";
          echo "&lt;td&gt;" . $row['pro_tax2'] . " &lt;/td&gt;";
          echo "&lt;td&gt;" . $row['pro_tax3'] . " &lt;/td&gt;";
          echo "&lt;/tr&gt;";
      }
      echo "&lt;/table&gt;";
  }
  </code></pre>
  
  <p>}</p>
  
  <p>please help...and thank you</p>