0 and lon <> 0 and postcode = '$postcode1'$extra"; $res = mysql_query($sqlquery); $num = mysql_num_rows($res); //Get lat and lon for postcode 2 $extra = ""; if ($suburb2 != '') { $extra = " and suburb = '$suburb2'"; } $sqlquery = "SELECT * FROM postcode_db WHERE lat <> 0 and lon <> 0 and postcode = '$postcode2'$extra"; $res1 = mysql_query($sqlquery); $num1 = mysql_num_rows($res1); if ($num != 0 && $num1 != 0) { //proceed $lat1 = mysql_result($res,0,"lat"); $lon1 = mysql_result($res,0,"lon"); $lat2 = mysql_result($res1,0,"lat"); $lon2 = mysql_result($res1,0,"lon"); $dist = calc_dist($lat1, $lon1, $lat2, $lon2); if (is_numeric($dist)) { return $dist; } else { return "Unknown"; } } else { return "Unknown"; } } ?>