I'd posted one on this list a couple years ago. Found it in the archive: http://lists.nyphp.org/pipermail/talk/2003-November/006445.html
I believe someone followed up and mentioned the actual source of the function, or at least a very similar one, but I can't seem to find that post. Good Luck, and have a great weekend, all. Mark > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Joseph Crawford > Sent: Friday, January 19, 2007 4:15 PM > To: NYPHP Talk > Subject: Re: [nyphp-talk] Radial Zip Code Search > > take a look here > http://www.hotscripts.com/PHP/Scripts_and_Programs/Zip_Code_Lo > cators/index.html > > On 1/19/07, Donald J Organ IV <[EMAIL PROTECTED]> wrote: > > WEll i am assuming you have a postal zipcodes database with > longitude > > and latitude here is the queries you want to use, first you need to > > get long and lat for zipcode > > > > SELECT longitutde,latitude > > FROM usa > > WHERE zipcode=$zip > > > > > > SELECT distinct zipcode, > > ROUND((ACOS((SIN($lat/57.2958) * SIN(latitude/57.2958)) + > > (COS($lat/57.2958) * COS(latitude/57.2958) * > > COS(longitude/57.2958 - $long/57.2958)))) * 3963, 3) AS > distance FROM > > usa WHERE (latitude >= $lat - ($miles/111)) AND (latitude <= $lat + > > ($miles/111)) AND (longitude >= $long - ($miles/111)) AND > (longitude > > <= $long + ($miles/111)) ORDER BY distance > > > > > > > > Baer, Jon wrote: > > > -----BEGIN PGP SIGNED MESSAGE----- > > > Hash: SHA1 > > > > > > You might want to try a new GIS topic search @ MySQL ... > > > > > > Here is an old one from 2004 - > > > http://forums.mysql.com/read.php?23,3868,3868 > > > > > > An inexpensive solution ... > > > http://www.myzipdb.com/zipcode_locator.php > > > > > > - - Jon > > > > > > - -----Original Message----- > > > From: [EMAIL PROTECTED] > > > [mailto:[EMAIL PROTECTED] > > > On Behalf Of Donna Marie Vincent > > > Sent: Friday, January 19, 2007 3:45 PM > > > To: [email protected] > > > Subject: [nyphp-talk] Radial Zip Code Search > > > > > > Hi, all. I am looking for a script, or a tutorial on how > to create > > > a script, that will perform a radial zip code search. I Googled > > > this "radial zip code" and "radial postcode" and have > found nothing > > > about how to do this. Can anyone point me in the right direction? > > > Thanks in advance! > > > > > > -----BEGIN PGP SIGNATURE----- > > > Version: GnuPG v1.4.3 (MingW32) > > > > > > iD8DBQFFsTAE99e5DI8C/rsRAmC/AKDq1EOwQO1WHnfXcXBDgmcPr3WPYwCcDrum > > > 8bFq8+ciezOt432+x/zgDCI= > > > =9lks > > > -----END PGP SIGNATURE----- > > > _______________________________________________ > > > New York PHP Community Talk Mailing List > > > http://lists.nyphp.org/mailman/listinfo/talk > > > > > > NYPHPCon 2006 Presentations Online > > > http://www.nyphpcon.com > > > > > > Show Your Participation in New York PHP > > > http://www.nyphp.org/show_participation.php > > > > > > > > _______________________________________________ > > New York PHP Community Talk Mailing List > > http://lists.nyphp.org/mailman/listinfo/talk > > > > NYPHPCon 2006 Presentations Online > > http://www.nyphpcon.com > > > > Show Your Participation in New York PHP > > http://www.nyphp.org/show_participation.php > > > > > -- > Joseph Crawford Jr. > Zend Certified Engineer > Codebowl Solutions, Inc. > http://www.codebowl.com/ > Blog: http://www.josephcrawford.com/ > 1-802-671-2021 > [EMAIL PROTECTED] > _______________________________________________ > New York PHP Community Talk Mailing List > http://lists.nyphp.org/mailman/listinfo/talk > > NYPHPCon 2006 Presentations Online > http://www.nyphpcon.com > > Show Your Participation in New York PHP > http://www.nyphp.org/show_participation.php > _______________________________________________ New York PHP Community Talk Mailing List http://lists.nyphp.org/mailman/listinfo/talk NYPHPCon 2006 Presentations Online http://www.nyphpcon.com Show Your Participation in New York PHP http://www.nyphp.org/show_participation.php
