Numbers

[mpar612]

I have a property website that allows users to search for properties and select a price range. If the user selects a price range between $170,000 and $180,000, they will also get results that are $1,700, $1,800 and $1,800,000.

Now, I update the database daily using LOAD DATA INFILE, which changes all of the data types in MySQL to mediumtext. That is what is causing the problem. If I change the type to INT, everything works great.

Does anyone have a way to make this work while keeping the type as mediumtext or does anyone have any recommendations on other ways to update the database that will not change the data type?

Thanks in advance.

[NogDog]

Well, by far my strongest recommendation would be to re-factor things so that the database column types correctly reflect the type of data being stored in them. If that is not a viable option for now, then you can do some type-casting in your query, e.g.:

$sql = "SELECT . . . WHERE CAST(`price` AS SIGNED) BETWEEN $low_price AND $high_price";

However, using the proper data type to begin with so that no casting is needed will not only simplify your code, but almost certainly will process faster, too.