Yes, after some further research, I found a Perl Modules that handles this queit
nicely.
thx's
[EMAIL PROTECTED] wrote:
I need to do a search query on the columns called
Name of business "the name of the business"
Town "Local town or city name"
Postcode " this is the same as your zip code"
Category "this is type of business ie dress shop bakers"
XY "this is the table of geo address maped by postcode"
I need the search to give me acurate results by the above fields.
Example: a user is searching Heywood postcode ol10 1jb and
category hotel,
We need to see the nearest hotel to that post code
and then the next nearest and so on up to 24 hotels
Is there way to query this in the same manner one would do it with
US zipcodes?
The only effective way to do this is with geographic coordinates (your
XY, I guess). While US zip codes _generally_ increase east to west and
_usually_ have a numeric difference somewhat related to their geographic
distance, this isn't always true. I know of two "island" zip codes
(unrelated to those that surround it) in New York State.
--
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]
