Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Zip Code Radius Search - Dreamweaver CS3

Author  Topic 

ayusufov
Starting Member

1 Post

Posted - 2009-05-15 : 20:14:10
Hey all,
I've been beating myself up with this for several weeks. I am trying to create a site using Dreamweaver CS3. The site requests a zipcode from the user and then returns all records that are within a 20 mile radius. I already have a database with all zipcode and their latitudes and longitudes and also have a second database with various records listed by zipcode. I have added latitude and longitude columns to the database with the various records and have filled them in the right latitudes and longitudes. I'm a beginner with SQL coding and could use all the help that anyone out there can provide. I have seen several versions of these calculations out there but none have worked. I am using Dreamweaver CS3 and phpMyAdmid. Please someone help me!!!!

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-06-04 : 05:13:49
See some code snippets in the Script Library poted by Michael Valentine Jones.


E 12°55'05.63"
N 56°04'39.26"
Go to Top of Page
   

- Advertisement -