Posted by Jeff North on 05/26/07 07:57

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]