Re: Problem with ordering by a calculated field

Generally, the Haversine Formula is the best one to calculate distance between two points, given the lat/long of both the client and the hotel.

See http://en.wikipedia.org/wiki/Haversine_formula for more information.

SELECT acos(sin(radians(P2.latitude)) * sin(radians(P2.latitude)) + cos(radians(P1.latitude)) * cos(radians(P2.latitude)) * cos(radians(P1.longitude) - radians(P2.longitude))) * 3963.1 AS distance

In CakePHP, you can implement that as a calculated field.

On Wednesday, August 1, 2012 8:26:53 AM UTC-4, yassine yas wrote:

hi daniel

i have the same probleme like you and i want to help me.

my english is not good.

well i develop a backEnd that receive the request of the client (lat & lng) and it's calculate the distance from the client to the hotels

how can i calculate the distance i calculated field and sort it

thanks

--
You received this message because you are subscribed to the Google Groups "CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com.
To unsubscribe from this group, send email to cake-php+unsubscribe@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php?hl=en-US.