I have a script which searches vehicles in our MYSQL database and am trying to add a price range search. The issue is if I enter 2000 (as the from price) and 3000 (as the to price), numbers higher than 3,000 are displayed if they contain the starting character (such as 10,995). Here is the code I'm using to query:
if($fPrice != "" && $tPrice != "")
$priceQuery=" AND varListPrice between '$fPrice' and '$tPrice'";
I'm very new to PHP and would really appreciate any help or opinions as to what's going wrong. Thanks!