NYCPHP Meetup

[Scott Mattocks]

I wrote this class that will get all zipcodes within a certain mile range.

http://www.phpclasses.org/browse/package/1640.html

It isn't so acurate when you get to extreme north and south locations 
due to the way longitude lines come together.  If you can't use the 
class as is, you should be able to pull out the query that you need. 
The class uses PEAR_DB so it is database independant.

Scott Mattocks

P.S. Sorry if this is the same as what others have posted. I have been 
away for a week and didnt' have time to reall all 300+ posts to this list.

Kshitij Bedi wrote:

> I have a database with zipcodes and corresponding latitudes and longitudes.
> Can anyone suggest a mysql statement that can pull me all zipcodes within 20
> or 50 or 100 miles of a given zipcode
> 
> Kshitij Bedi 
> Web Administrator 
> International Trademark Association 
>  
> _______________________________________________
> talk mailing list
> talk at lists.nyphp.org
> http://lists.nyphp.org/mailman/listinfo/talk
> 
>