| Re: Calculate the distance between 2 points [message #171314 is a reply to message #171289] |
Thu, 30 December 2010 09:31   |
The Natural Philosoph
Messages: 993
Registered: September 2010
Karma:
|
Senior Member |
|
|
Bill Braun wrote:
> 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.
No. its the time of year when thick students who haven't done their
coursework expect someone else to do it for them.
> Is this place the meeting
> ground of choice for miserable people?
>
No, its a place where people who should have listened to lectures, come
for answers they have actually learnt already.
> You can express an opinion in decent, respectful language. But crude and
> insulting behavior gets no pass from me.
>
And students who cheat and crib get no pass from me either.
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]