How to do a geometric search using latitude and longitude using php and mysql

Question

Hi all,

Did any know about how to search using latitude and longitude using latitude and longitude using php and mysql as back-end.

I am having zip-code and latitude and longitude for the corresponding city.

If i enter for a search with latitude i need to know the name of the city with that corresponding latitude and longitude.

With these things as back-end how can i do my search.

thanks in advance.

Answer 1

You'd be wanting a GeoSpatial database to do true geometric searches. There's a chapter about it in the MySQL manual

http://dev.mysql.com/doc/refman/5.0/en/gis-introduction.html