Zipcode search function

function getZipWithinXMilesNew($searchMiles, $country, $latitude, $longitude, $mDatabase)
{
$equatorLatMile = 69.172;
$PI = 3.14159265358979;
$maxLatitude = $latitude + $searchMiles / $equatorLatMile;
$minLatitude = $latitude – ($maxLatitude – $latitude);
$maxLongitude = $longitude + $searchMiles / (Cos($minLattitude * $PI / 180) * $equatorLatMile); $minLongitude = $longitude – ($maxLongitude – $longitude);
if($country == “US”)
$sqlZip = “SELECT DISTINCT(ZIPCode) as zip FROM “.__TBL_US_ZIP.” WHERE ( Latitude <= “.$maxLatitude.” AND Latitude >= “.$minLatitude.” ) AND ( Longitude >= “.$minLongitude.” AND Longitude <= “.$maxLongitude.” ) “;
if($country == “CANADA”)

$sqlZip = “SELECT DISTINCT(PostalCode) as zip FROM “.__TBL_CANADA_ZIP.” WHERE Latitude <= “.$maxLatitude.” AND Latitude >= “.$minLatitude.” AND Longitude >= “.$minLongitude.” AND Longitude <= “.$maxLongitude; #print $sqlZip.””;
$rsZip = $mDatabase->ExecuteQuery($sqlZip); if($mDatabase->NumRows($rsZip) > 0)
{
$resZip = $mDatabase->FetchArray($rsZip);
foreach($resZip as $value)
{
$arrZip[] = $value[‘zip’];
}
return $arrZip;
}
else
return 0;
}