// At least the unknown coordinates are first in the queue.
while ($aFam = mysql_fetch_array($rsFamilies)) {
extract($aFam);
$myAddressLatLon->SetAddress($fam_Address1, $fam_City, $fam_State, $fam_Zip);
$ret = $myAddressLatLon->Lookup();
if ($ret == 0) {
$sNewLatitude = $myAddressLatLon->GetLat();
$sNewLongitude = $myAddressLatLon->GetLon();
if ($sNewLatitude === NULL) {
$sNewLatitude = 0;
}
// if a lookup returned zero skip this. Don't overwrite with 0,0
if ($sNewLatitude != 0) {
echo "<p>" . $fam_Name, " Latitude " . $sNewLatitude . " Longitude " . $sNewLongitude . "</p>";
$sSQL = "UPDATE family_fam SET fam_Latitude='" . $sNewLatitude . "',fam_Longitude='" . $sNewLongitude . "' WHERE fam_ID=" . $fam_ID;
RunQuery($sSQL);
}
} else {
echo "<p>" . $fam_Name . ": " . $myAddressLatLon->GetError() . "</p>";
}
flush();
}
echo '<p>' . gettext('Update Finished') . '</p>';
$sSQL = "SELECT fam_ID, fam_Name, fam_Address1, fam_City, fam_State, fam_Zip, fam_Latitude, fam_Longitude ";
$sSQL .= "FROM family_fam WHERE fam_Latitude = 0";
$rsFamilies = RunQuery($sSQL);
while ($aFam = mysql_fetch_array($rsFamilies)) {
extract($aFam);
echo "<p> No coordinates found for " . $fam_Name . " " . $fam_Address1 . "," . $fam_City . "," . $fam_State . "," . $fam_Zip . "</p>";
}
ob_flush();
