Problem with search and values of DB

database problem

[pocweb]

I have a database search designed by someone else that searches real estate listings. One of the searches allows you to put in Maximium Square footage and Minimum Square footage to filter your results. Problem is that buildings with a square footage over 10,000 are not being treated properly. Its as if the search doesn't recognize all the numbers (or 0's). A building with 115,000 square footage shows up when I search for buildings between 0 and 10000 sq ft.

Since this was designed by someone else I'm unfamiliar with its set up and this certainly is not my strength. It looks like its designed with smarty templates. I have no idea where to even start looking for the mistake. Any hints on what or where the files that need modifying would be appreciated.

[phranque]

welcome to WebmasterWorld, pocweb!

is the square footage column type numeric or text?

[pocweb]

The type says "float"

Thanks for the warm welcome!

[LifeinAsia]

It might help to post the actual query being used to get the data.