Hi, ok thank you, If i do the following
SELECT userid FROM location WHERE longitude BETWEEN -80 and -94 AND latitude BETWEEN 30 and 49 AND 3963 * acos(cos(radian(90-place.lat)) * cos(radians(90-mylat)) + sin(radians(90-place.lat)) * sin(radians(90-mylat)) * cos(radians(place.lon-mylon))) < 1000 Because the problem, is that I have to join this with 3 other tables. Thanx Agai. Anthony W. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]