mysql & code

[leest]

Ok,

 

I posted a code earlier and finally got it orking, the problem now is i got a it ambitious, and found this tutorial script I have played around with it and changed a few things but when i run it, it returns a blank page.  with no information i have echo checked the databse etc and all is working perfec, but i think i am losing it when it starts the geo code part.

 

Does any body have any ideas???

 

define("MAPS_HOST", "maps.google.com");
define("KEY", "ABQIAAAAVwap6S1SY6Dy31wrLpcgMxRBjdw_Uqb4fDsWbJeQLrPjg6_7hxRMhG5Acz3cLO1a6difeC85xaXsMA");


// Select all the rows in the markers table
$query = "SELECT * FROM joborder ";
$result = mysql_query($query);
if (!$result) {
  die("Invalid query: " . mysql_error());
}

// Initialize delay in geocode speed
$delay = 0;
$base_url = "http://" . MAPS_HOST . "/maps/geo?output=xml" . "&key=" . KEY;

// Iterate through the rows, geocoding each address
while ($row = @mysql_fetch_assoc($result)) {
  $geocode_pending = true;

  while ($geocode_pending) {
    $state = $row["state"];
    $joborder_id = $row["joborder_id"];
    $request_url = $base_url . "&q=" . urlencode($state);
    $xml = simplexml_load_file($request_url) or die("url not loading");

    $status = $xml->Response->Status->code;
    if (strcmp($status, "200") == 0) {
      // Successful geocode
      $geocode_pending = false;
      $coordinates = $xml->Response->Placemark->Point->coordinates;
      $coordinatesSplit = split(",", $coordinates);
      // Format: Longitude, Latitude, Altitude
      $lat = $coordinatesSplit[1];
      $lng = $coordinatesSplit[0];

      $query = sprintf("UPDATE joborder " .
             " SET lat = '%s', lng = '%s' " .
             " WHERE joborder_id = '%s' LIMIT 1;",
             mysql_real_escape_string($lat),
             mysql_real_escape_string($lng),
             mysql_real_escape_string($joborder_id));
      $update_result = mysql_query($query);
  echo  $row['joborder_id'];
  
      if (!$update_result) {
        die("Invalid query: " . mysql_error());
      }
    } else if (strcmp($status, "620") == 0) {
      // sent geocodes too fast
      $delay += 100000;
    } else {
      // failure to geocode
      $geocode_pending = false;
      echo "Address " . $state . " failed to geocoded. ";
      echo "Received status " . $status . "\n";
    }
    usleep($delay);
  }
}

[blackcell]

Place echos in within each while loop to figure out how far you are making it into the mess. Evidentially your not satisfying some arguments if your returning a blank page because the if statements containing your echo's aren't true.

[leest]

i'll give it a go thanks