Sometime it is necessary to list items which are close by geographically. If you have the longitude and latitude then this is a simple matter and can be done within one sql statement.
An example implementation is shown below. As companies very rarely change location, and this query will cause MySql to traverse each row in the table everytime it is run, the results here are cached using Zend Cache.




