I've got a web site in beta testing right now. I've come across a bug
that is turning up some strange results.
I'm doing a query "select SQL_CALC_FOUND_ROWS
from residential where City like "McMinnville" OR City like "Yamhill"
and ListPrice >= 1000 and ListPrice <= 500000 and NumberofBedrooms >= 1
AND TotalBathrooms >= 1 order by ListPrice desc LIMIT 10,10"
But the return list is spitting back results that are out size of the
range specified by listprice.
You can view the qery and result here:
[url]http://www.oregon-properties.net/cgi-bin/homesearch3.pl?city=McMinnville&city=Yamhill&low=1 000&high=500000&beds=1&baths=1&limit=10&offset=10& pre=1&sort=desc[/url]
Any ideas where I may be going wrong?...