Hi, You mention this
SELECT loc1.name, loc1.lat, loc1.lon, loc2.name, loc2.lat, loc2.lon, 3963 * acos(cos(radians(90-loc1.lat)) * cos(radians(90-loc2.lat)) + sin(radians(90-loc1.lat)) * sin(radians(90-loc2.lat)) * cos(radians(loc1.lon-loc2.lon))) AS Miles FROM locations AS loc1 INNER JOIN locations AS loc2 ON loc1.id = 1 AND loc2.id = 2 the only problems is that I have tremendous problem understanding AS, I think it is creating a "virtual" column name called Miles. Also, if i search people that are about 100miles or XXmiles away from me, how do i check that because I don't understand the use of loc1.id=1 and loc2.id=2 Thanx for the help. Anthony -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
