<[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> "Shaun" <[EMAIL PROTECTED]> wrote on 01/23/2006 11:51:32 AM:
>
>> Hi,
>>
>> We have a dataset of uk postcodes and their relevant X-Coordinates and
>> Y-Coordinates, a table of properties (houses), a table of users and a
> table
>> of o
Postcodes table, and the associated coordinates you want to
match on.
HTH
Keith
In theory, theory and practice are the same;
In practice they are not.
On Mon, 23 Jan 2006, Shaun wrote:
> To: mysql@lists.mysql.com
> From: Shaun <[EMAIL PROTECTED]>
> Subject: Postcode Search
&
We use the inradius function as described here:
http://www.phparch.com/discuss/index.php?t=msg&th=878
It's not the fast way I'm sure but seems to be pretty reliable.
Instead of the zipdata table you would point it at the Postcodes table
and the Properties table. You'll also need to add an X,Y (
"Shaun" <[EMAIL PROTECTED]> wrote on 01/23/2006 11:51:32 AM:
> Hi,
>
> We have a dataset of uk postcodes and their relevant X-Coordinates and
> Y-Coordinates, a table of properties (houses), a table of users and a
table
> of offices - users work in an office - table structures below.
>
> Is i
Hi,
We have a dataset of uk postcodes and their relevant X-Coordinates and
Y-Coordinates, a table of properties (houses), a table of users and a table
of offices - users work in an office - table structures below.
Is it possible to run a search of all properties in the properties table
that co
