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

Did any know about how to search using la开发者_如何学Pythontitude 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.

---

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