Hi, I need to calculate distance from a point and for the select statment I have this
SELECT userid FROM place WHERE acos( cos($longitude) * cos($latitude) * cos(place.latitude) *cos(place.longitude) +cos($longitude) * sin($latitude) * cos(place.latitude) * sin(place.longitude) +sin($longitude) * sin($latitude) ) * 3963 <= 1000); Would you consider this HORRIBLY inefficient or GOOD. if it is horrible how can i make it efficient? Anthony -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
