title: SQL Query Price Compare
body: <p>I am running a SQL query to seach my database. I can currently search everything until i compare prices. </p>
  
  <p><strong>Working Code Without Price Compare</strong></p>
  
  <pre><code>$query = "SELECT * FROM propertie_ids WHERE (`search` LIKE '%".$searchquery."%') AND (`location` = '$location') AND (`bathroom` = '$bathroom') AND (`bedroom` = '$bathroom');
  </code></pre>
  
  <p><strong>Broken Code With Price Compare</strong></p>
  
  <pre><code>$query = "SELECT * FROM propertie_ids WHERE (`search` LIKE '%".$searchquery."%') AND (`location` = '$location') AND (`bathroom` = '$bathroom') AND (`bedroom` = '$bathroom') AND price BETWEEN ('0') AND  ('10000000000')";
  </code></pre>
  
  <p>Any ideas why this does not work, I have checked and all my tables are named correctly.</p>