I have a list of all colleges and universities in the United States. Unfortunately, I do not have the addresses (street, state, zip code).
I need a PHP script that allows me to read through a mySql table of school names (and IDs) and return the address of the school(s) for saving into a mySql table.
I am not even sure if this is possible, but thought I would see. The idea I had was for the script to pass the college name ("find a business" field in MapQuest) to the MapQuest website and then when MapQuest suggests an address through the "relevance" tab, capture that address for the school.
This was just my first thought. I look forward to seeing what the pros come up with
Thanks in advance,
Adam