Hello. I am new to this forum. I am not sure if this is the correct forum to post this since it is both a MySQL and a PHP issue. I have tried searching but have not found anything...yet (but still looking).
I have a website where organizations can submit their addresses (full mailing address). I then take that address and convert it manually into GPS coordinates and enter that into 'lat' and 'lng' fields in the same table. Once the GPS is entered a marker is displayed on a Google map. All that os good.
What I want to do is have it converted to GPS coordinates automatically. I do not know how to go about this. Is there an online source that I can somehow tie my database to to have it converted automatically? I am at a loss on how to go about this one.
Any guidance would be very appreciated!
PHP 5.2.17
MySQL 5.1.62-cll
Apache