Best Way to to Execute functions and write to a database within a while loop

I want to use the Google Geocode system to look up Lat/Long coordinates on addresses which are in a MySQL database and write them back to the same database.

I am looking for suggestions about the best approach.

The code I'm using to lookup and write back the coordinates is in two php files, one called by the other.  Since they must go to Google's server to do the lookup, there is some delay.

I have tried calling those php files from within the while loop used to step through the database, but it only writes the coordinates to the first record.  Perhaps I need to pause the while loop and make it wait for a return from the Google lookup?

<table>
  <?php do { ?> 
  <tr>
    <?php echo $row_rsContacts_List['First_Name']; ?></td>
    <?php echo $row_rsContacts_List['Last_Name']; ?></td>
    <?php echo $row_rsContacts_List['Address1']; ?></td>
    <?php echo $row_rsContacts_List['Address2']; ?></td>
    <?php echo $row_rsContacts_List['City']; ?></td>
    <?php echo $row_rsContacts_List['State']; ?></td>
    <?php echo $row_rsContacts_List['Zip']; ?></td>

    <?php  // Set address values to session variables to be used by the 
		   // files that cdo the Google Geocode lookup
				$_SESSION['MAP_Geocode'] = "Y";
				$_SESSION['MAP_Street'] = $row_rsContacts_List['Address1'];
				$_SESSION['MAP_City'] = $row_rsContacts_List['City'];
				$_SESSION['MAP_State'] = $row_rsContacts_List['State'];
				$_SESSION['MAP_Zip'] = $row_rsContacts_List['Zip'];
		// Open self-closing popup window load the files that do the Google Geocode lookup
		echo "<script type='text/javascript'>
			WindowName = window.open('../mapping/geocode.php', 'Geocode', 'width=400,height=200,scrollbars=yes');
			WindowName.moveTo(400,200);
			WindowName.focus();
			</script>";				
	?>
    <?php $rownum ++; ?>
  </tr>
  <?php } while ($row_rsContacts_List = mysql_fetch_assoc($rsContacts_List)); ?>
</table>  

Select all Open in new window

Solutions would be appreciated!