geocoder proximity within 1 mile

Hi,

Do you get results properly when searching for distances other than 1 mile?

If you could fill out a [url http://www.interactivetools.com/support]2nd Level Support Request[/url] we can take a closer look.

thanks

Yes, 2 miles works.

I just combined the examples of proximity search and multi map display and everything works perfect except when trying to do distance within 1 mile.

the url is www.stoddardmls.com/proximity.php and i have attached the file

Hi,

That's strange. If you could fill out a [url http://www.interactivetools.com/support]2nd Level Support Request[/url] we can take a look into this for you.

Hope this helps

Hi,

In order to be able to try to find the root cause of this issue, we'll need to be able to see the script running and run some tests. So we'll need to have access to the server/ installation. If you could fill out a [url http://www.interactivetools.com/support]2nd Level Support Request[/url] we can take a closer look.

Hope this helps

Hi,

I took a look into this. The reason you cannot return anything within 1 mile is that, technically, you don't have any posts within 1 mile of your default zip code. The distance of your nearest zip code, in miles, is calculated as : 1.00949717326923, which the script interprets as being greater than 1, so it's disregarded.

You can control the precision being used by using the MySQL TRUNCATE function. For example, if you want it to only look at the first two decimal places, you can alter the HAVING clause of your query like this:

'having' => "TRUNCATE(_distance, 2) <= " . $maxDist, // only show results within max distance

If you don't want it to look at decimal places at all, you can use 0 like this:

'having' => "TRUNCATE(_distance, 0) <= " . $maxDist, // only show results within max distance

Hope this helps