using latitude and longtidue

[CousiMo]

is there a way to calcualte how many miles the contact is from our location.?

if we are hosting an event, we would like to invite participants living within 60 miles,

[Donald Lobo]

no

[petednz]

How important is it for you? I have been looking in to some GIS options. I doubt this would be that tricky. I can't offer any advice but would be happy to share ideas on approach. Basically it requires querying the database for any contacts whose geocoords fit within the polygon defined by , in your case, the circle centred on your location.

[JoeMurray]

Check out Drupal's proximity searches - I think they do this well. You may be able to create a custom view that would include the location lat/long and then be able to leverage the views proximity functionality. You may want to also explore usernode, nodeprofile and location modules if necessary.

Not sure whether Joomla! has this functionality.

[Donald Lobo]

I borrowed liberally from drupal's location module and hacked a custom search to do this. You can get the custom search code here:

http://svn.civicrm.org/civicrm/trunk/CRM/Contact/Form/Search/Custom/Proximity.php

lobo