DOES NOT WORK SYSTEM ONLY RETURNS SUCCESS OR FAILURE!!! take-away.com.au
MAJOR PROBLEM! CONTACT TECHNICAL HELP ON 0405104934 A.S.A.P.
$query
"); } else { $row = msqlFetchRow($res); while (#$row > 0) { $from_postcode = $row[0]; $from_city_suburb = $row[1]; $from_state = $row[2]; $from_lat = $row[3]; $from_lon = $row[4]; /* echo("$row[0] $row[1] $row[2] $row[3] $row[4]
");*/ $query2 = "select postcode,city_suburb,state,lat,lon from postcodes_lat_lon_2"; if (msqlQuery($sock, $query2) < 0) { fatal("Error : $ERRMSG\n"); } $res2 = msqlStoreResult(); $num_rows2 = msqlNumRows($res2); if ($num_rows2 < 1) { echo("

MAJOR PROBLEM! CONTACT TECHNICAL HELP ON 0405104934 A.S.A.P.
$query

"); } else { $counter = 0; $row2 = msqlFetchRow($res2); while (#$row2 > 0) { $to_postcode = $row2[0]; $to_city_suburb = $row2[1]; $to_state = $row2[2]; $to_lat = $row2[3]; $to_lon = $row2[4]; /* echo("$row2[0] $row2[1] $row2[2] $row2[3] $row2[4]
");*/ $result = ""; if($from_postcode != $to_postcode) { system("`/usr/local/apache2.2/htdocs/take-away/get_distance $from_lat $from_lon $to_lat $to_lon` > 'distance.txt'"); system("cat distance.txt"); } $row2 = msqlFetchRow($res2); if ($counter > 100) { exit(0); } $counter++; } } $row = msqlFetchRow($res); } } msqlFreeResult($res); msqlClose($sock); >