http://code.google.com/apis/maps/articles/phpsqlgeocode.html article has a way to select addresses from your database and geocode them.
But for some addresses, you may get an error "Received status 400" which happens when you send data to them not in UTF8 encoding. This post says they require your input to be utf8 http://groups.google.com/group/google-maps-api-notify/browse_thread/thread/58e416415af46671?pli=1 and Google will return error G_GEO_BAD_REQUEST (400) if you don;t. If your data in your database is not coming out in utf8, you can get mysql to automatically make your result sets in utf8 by doing this query before selecting any addresses from your database: mysql_query("SET character_set_results = 'utf8'"); Now all subsequent queries for that mysql session will give results in UTF8, eliminating the google Status 400 error. -- You received this message because you are subscribed to the Google Groups "Google Maps API" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/google-maps-api?hl=en.
