Re: Sorting users geographically...
| From: | Marcus Bointon | Date: | Mon, 21 Nov 2005 17:43:06 +0000 |
| Subject: | Re: Sorting users geographically... | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-226220@lists.php.net to get a copy of this message | ||
On 21 Nov 2005, at 14:14, Tony Di Croce wrote:
Does anyone know of any commercial or free implementations of this? Is it primarily a database problem or is their some way (computationally) to compute the probable proximity of two zip codes?All the suggested packages could be all you need, but also note that MySQL 5 has built-in GIS features which may make searches like these way more efficient should they use them: http://dev.mysql.com/doc/refman/5.0/en/spatial-extensions-in-mysql.html http://dev.mysql.com/doc/refman/5.0/en/functions-that-test-spatial-relationships-between-geometries.html Marcus -- Marcus Bointon Synchromedia Limited: Putting you in the picture marcus@synchromedia.co.uk | http://www.synchromedia.co.uk