Re: Zip Code Proximity search

[Robin Meeuwsen]

> $sql = 'SELECT ... FROM items ... WHERE';
>
> $distance_lookup_slop_miles = 5;
>
> $delta_latitude = (($radius +
> $distance_lookup_slop_miles) / 69.172);
> $lat1 = $latitude + $delta_latitude;
> $lat2 = $latitude - $delta_latitude;
> $delta_longitude = (($radius +
> $distance_lookup_slop_miles)
> / (cos($latitude) * 69.172));
> $long1 = $longitude + $delta_longitude;
> $long2 = $longitude - $delta_longitude;
> $sql .= ' AND items.latitude <= ' . $lat1
> . ' AND items.latitude >= ' . $lat2
> . ' AND items.longitude <= ' . $long1
> . ' AND items.longitude >= ' . $long2;

Can you give me a greater insight on this? Your code is very interesting for something I'm now working on but I'm missing some details. With which values are the variables radius, latitude and longitude filled? I have a database with all the villages in France and their corresponding latitudes and longitudes in decimal format. If I would like to use your code how would it look like?

Kind regards,

Robin MEEUWSEN



Edited 1 time(s). Last edit at 08/30/2006 12:57PM by Robin Meeuwsen.