| Re: Calculate the distance between 2 points [message #171289 is a reply to message #171284] |
Thu, 30 December 2010 01:42   |
me
Messages: 192
Registered: September 2010
Karma:
|
Senior Member |
|
|
On 12/29/2010 8:23 PM, Thomas 'PointedEars' Lahn wrote:
> Sarah wrote:
>
>> I know this
>>
>> $distanceValue =
>> rad2deg(acos(sin(deg2rad($LATITUDINE1))*sin(deg2rad($LATITUDINE2))
>>
> +cos(deg2rad($LATITUDINE1))*cos(deg2rad($LATITUDINE2))*cos(deg2rad($LONGITU DINE1-
>> $LONGITUDINE2))))*69.09;
>>
>> or something like this.... but I don't want to have all records of DB
>> and than analize them one by one .... I want a query the return only
>> nearest values
>
> So RTFMySQLM.
>
>
> PointedEars
It seems to be the time of year, or possibly the lunar cycle, for
bullies to crawl out from under their rocks. Is this place the meeting
ground of choice for miserable people?
You can express an opinion in decent, respectful language. But crude and
insulting behavior gets no pass from me.
Dial it down, Pointed Ears.
Bill B
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]