title: Mysql Select between two price vaues
body: <p>I need to select my price column in MySQL table. There are two input types, one is minimum price and other one is maximum price. According to these price values I need to select my price in DB table. So, I am using this query.</p>
  
  <pre><code>SELECT * 
    FROM properties 
   WHERE category LIKE '$property_for' 
     AND property_type LIKE '$property_type' 
     AND search_radius &gt;= '$area' 
     AND location LIKE '$location'  
     AND bed_rooms LIKE '$beds' 
     AND bath_rooms LIKE '$baths' 
     AND price &lt; '$price_max' 
     AND price &gt; '$price_min'  
   ORDER 
      BY date_added DESC
  </code></pre>
  
  <p>But it not work for me. So, Please help me for this problem.</p>