Error: Unable to find $ZipCode\n");
echo("in ZipCode database.
Unable to calculate distances.\n");
} else {
$sql->Fetch(0);
$lat1 = $sql->data[Lat];
$lng1 = $sql->data[Lng];
/* Ok, the first thing to do here is loop through the Locations
* table and determine which of the locations are within the distance
* specified. Note the use of a massive join. That probably won't work
* if the database gets a signifigant number of items in it.
*/
$min = 99999999;
$sl1 = Sin($lat1);
$cl1 = Cos($lat1);
$join = "select Auctions.ID, Auctions.Name, Auctions.StartTime, Locations.City, Locations.State, ZipCode.Lat, ZipCode.Lng from Locations, Auctions, ZipCode where Auctions.Location = Locations.ID and Locations.ZipCode = ZipCode.ZipCode";
$sql->Query($join);
for ($i = 0; $i < $sql->rows; $i++) {
$sql->Fetch($i);
$id = $sql->data[0];
$name = $sql->data[1];
$stime = $sql->data[2];
$city = $sql->data[3];
$state = $sql->data[4];
$lat2 = $sql->data[5];
$lng2 = $sql->data[6];
/* Distance between two points on a sphere in radians */
$dist = Acos($sl1 * Sin($lat2) + $cl1 * Cos($lat2) * Cos($lng2 - $lng1));
/* Convert to Miles or Km */
if ($Units == "Miles") {
$dist = (int)(3963.0 * $dist);
} else {
$dist = (int)(6377.83 * $dist);
}
if ($dist < $min) {
$min = $dist;
}
if ($dist <= $Dist) {
/* Ok, we found one, add it to the list. Putting everything
* into a list like this allows us to do a sort on the data
* after we've finished looping through it all.
*/
$Found[$id] = $dist;
$CitySt[$id] = "$city, $state";
$StartTime[$id] = $stime;
$Name[$id] = $name;
}
}
/* Now that we've got the list of all the auctions within the specified
* distance, sort them by distance, closest to furtest, and print'em
* out.
*/
if ($Found) {
echo("
| Auctions within $Dist $Units | |||
|---|---|---|---|
| Name | Start Time | Location | Distance ($Units) |
| $Name[$id] | \n"); echo("$StartTime[$id] | \n"); echo("$CitySt[$id] | \n"); echo("$Found[$id] |
Sorry, No auctions found within $Dist $Units. \n"); echo("The closest auction found is $min $Units from you.\n"); } } } include("footer.php3"); ?>