Find all records in database that are within a certain distance of a set of lat and long points
- by Mike L
I've seen all the examples and here's what I got so far.
my table is simple:
schools (table name)
- School_ID
- lat
- long
- county
- extrainfo
here's my code:
<?php
$con = mysql_connect("xxx","xxx","xxx");
if (!$con) {
die('Could not connect: ' . mysql_error());
} else {}
mysql_select_db("xxx", $con);
$latitude =…