Hi Mike, Sorry for the late reply. The company I work for has this very same problem -- we are a multi-national personal ad site, where members can search for other members close to them.
The answer is, unfortunately, you have to acquire one database with postcodes, and another with longitudes and latitudes, and merge them together. We spent a lot of time finding that answer, and when we did, it wasn't cheap. Sorry for the bad news. -Sheeri Kritzer On 1/7/06, Mike Blezien <[EMAIL PROTECTED]> wrote: > Hello, > > we are working with a database that stores UK postcodes, which are different > then US zipcodes. I've found alot of information for working with zipcodes, > locating closed distances within a zipcode range, but haven't found anything > regarding working with UK type postcodes. > > Was hoping someone on the list may have worked with UK postcodes and may have > some info on the best way to query these postcodes for locating closed > location, > distances,.etc? > > thx's > > -- > Mike(mickalo)Blezien > =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= > Thunder Rain Internet Publishing > Providing Internet Solutions that work! > http://thunder-rain.com/ > =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
