Posted by larry on 05/26/07 04:21

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.

[Back to original message]