mySQL Geospacial Query - Geo Distance Search with MySQL

The new app will need to be able to determine the "Closest" vendor relative to the device location. Getting the location of the device is mostly simple. There are plenty of tutorials to show you how to add the library and hook thinks together.

But how do you search for the closet vendor on the back end using mySQL.

Here is an article on how you can roll your own
http://www.scribd.com/doc/2569355/Geo-Distance-Search-with-MySQL

Hope this helps
James