Re: Zip Code Proximity search

[john.pedersen]

I have the same problem, also for a dating site.

I have a number of searches working using idea of precalculating a max and min latitude and longitude and then searching for users who have locations with those coordinates. Works well for searching for users within 10 miles, 50 miles whatever.

But I would also like to have a search where the results are ordered by distance apart. I don't want to have to search for users within 100 miles, then calculate the distances between them programatically, reorder them, then pick the first 10.... and then do something similar for the next 10.

I have looked briefly at the GIS extensions, but it seems Distance(g1,g2) isn't implemented yet, so it doesn't look as if that will serve the purpose.

Has anyone come up with a solution yet?

Thanks,

John Pedersen