Advanced Search

Return to Snippet

Revision: 9889
at November 28, 2008 04:32 by jamesming
Initial Code 
SELECT id, place_name,
ROUND( SQRT( POW((69.1 * (#Val(arguments.latitude)# - latitude)), 2) + POW((53 * (#Val(arguments.longitude)# - longitude)), 2)), 1) AS distance
FROM places
Initial URL 
http://www.petefreitag.com/item/622.cfm
Initial Description 

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
MYSQL FORMULA TO LIST NEAREST  LOCATIONS FROM TWO GEO COORDINATES

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
SQL