FUDforum: comp.lang.php » Calculate the distance between 2 points

Home » Imported messages » comp.lang.php » Calculate the distance between 2 points

Show: Today's Messages :: Polls :: Message Navigator

Re: Calculate the distance between 2 points [message #171380 is a reply to message #171275]

Fri, 31 December 2010 02:25

Martin
Messages: 8
Registered: October 2010

Karma:

Junior Member

On Dec 29, 11:55 pm, Sarah <dandi....@gmail.com> wrote:
> Hi! I've a table with a list of record that have latitude and
> longitude
>
> I've know new point with a position (new lati and new longi)
>
> how can I show all records that have a distance <= of XX Kilometers??
>
> Is it possible?
>
> Thanks

There's a demo here that might be of use to you:

http://code.google.com/apis/maps/articles/phpsqlsearch.html

Scroll down the page to 'Finding locations nearby with MySQL'.

Martin.

Report message to a moderator

[Message index]

		Calculate the distance between 2 points By: Sarah on Wed, 29 December 2010 23:55
		Re: Calculate the distance between 2 points By: Denis McMahon on Thu, 30 December 2010 00:02
		Re: Calculate the distance between 2 points By: Sarah on Thu, 30 December 2010 00:34
		Re: Calculate the distance between 2 points By: Thomas 'PointedEars' on Thu, 30 December 2010 00:42
		Re: Calculate the distance between 2 points By: The Natural Philosoph on Thu, 30 December 2010 09:28
		Re: Calculate the distance between 2 points By: Sarah on Thu, 30 December 2010 00:43
		Re: Calculate the distance between 2 points By: RMP on Thu, 30 December 2010 01:06
		Re: Calculate the distance between 2 points By: Thomas 'PointedEars' on Thu, 30 December 2010 01:23
		Re: Calculate the distance between 2 points By: me on Thu, 30 December 2010 01:42
		Re: Calculate the distance between 2 points By: Jerry Stuckle on Thu, 30 December 2010 04:53
		Re: Calculate the distance between 2 points By: The Natural Philosoph on Thu, 30 December 2010 09:31
		Re: Calculate the distance between 2 points By: me on Thu, 30 December 2010 09:37
		Re: Calculate the distance between 2 points By: The Natural Philosoph on Thu, 30 December 2010 09:47
		Re: Calculate the distance between 2 points By: me on Thu, 30 December 2010 13:04
		Re: Calculate the distance between 2 points By: Felix Saphir on Thu, 30 December 2010 18:32
		Re: Calculate the distance between 2 points By: me on Thu, 30 December 2010 18:48
		Re: Calculate the distance between 2 points By: Jerry Stuckle on Thu, 30 December 2010 13:10
		Re: Calculate the distance between 2 points By: Denis McMahon on Thu, 30 December 2010 12:15
		Re: Calculate the distance between 2 points By: me on Thu, 30 December 2010 12:31
		Re: Calculate the distance between 2 points By: The Natural Philosoph on Fri, 31 December 2010 02:13
		Re: Calculate the distance between 2 points By: Jerry Stuckle on Thu, 30 December 2010 04:58
		Re: Calculate the distance between 2 points By: RMP on Thu, 30 December 2010 09:23
		Re: Calculate the distance between 2 points By: The Natural Philosoph on Thu, 30 December 2010 09:28
		Re: Calculate the distance between 2 points By: Martin on Fri, 31 December 2010 02:25

Previous Topic:	Checking equal number of <div> and </div>
Next Topic:	extract variable from an array

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 05:52:41 GMT 2024

Total time taken to generate the page: 0.05255 seconds