|
|
Posted by Veign on 05/26/07 17:13
I did something similar for this website (just for fun and to test things):
http://distancecheck.com/
It uses the Long and Lat to calculate the distance between two US zip codes.
It would be quite easy to create an area type search that covers, say, a 30
mile radius.
--
Chris
http://www.veign.com / http://www.veign.com/blog
--
"Jeff North" <jnorthau@yahoo.com.au> wrote in message
news:e3qf53thhi490b2somlh7n9jgkt58kk9la@4ax.com...
> On 25 May 2007 21:21:17 -0700, in comp.lang.php
> larry@portcommodore.com
> <1180153277.105579.233190@m36g2000hse.googlegroups.com> wrote:
>
>>| On May 25, 8:24 am, Jeff North <jnort...@yahoo.com.au> wrote:
>>| > I've searched the web for weeks (on and off) but can't find any
>>| > information about the topic.
>>| >
>>| > A client wants to set up a franchisee structure and track this
>>| > information via a database.
>>| >
>>| > I've never done this and uncertain of how I would do it.
>>| >
>>| > Initially the client only wants state by state franchisees but I can
>>| > see that this could eventually be scaled to districts/areas.
>>| >
>>| > To compound matters, my client is wanting this to work in any country.
>>| >
>>| > Has anyone got any pointers as to information that I can start looking
>>| > at?
>>| > ---------------------------------------------------------------
>>| > jnort...@yourpantsyahoo.com.au : Remove your pants to reply
>>| > ---------------------------------------------------------------
>>|
>>| You could always put latitude and longitude in a DB table and then use
>>| an area search. I read about it in some posting about MySQL but it is
>>| still a ways off for me to look at presently.
>>|
>>| It involves with the spatial extensions of MYSQL:
>>| http://dev.mysql.com/doc/refman/5.0/en/spatial-extensions.html
>>|
>>| With these you can 'map out a region" in your query.
>>|
>>| Not much detail, but it's a start for something to google at least.
>
> I thought of that but couldn't find much information. Also my client's
> ISP is still using php/mysql 4.x :-(
> ---------------------------------------------------------------
> jnorthau@yourpantsyahoo.com.au : Remove your pants to reply
> ---------------------------------------------------------------
[Back to original message]
|