You have chosen to sponsor your bid up to a maximum amount of .
explanation: I have members with incomplete addresses.
for example Joe, Berlin cannot be imported into a google map because street name is not there.
this is why we get the coordinates of Berlin using worldwide table with city coordinates
giving Joe, 18.104.22.168, 17367040 will put joe exactly into Berlin on the map
now we want to put joe randomly in a distance to the center of Berlin using a Random number, because there might be others in Berlin and we dont want the marker to be exactly on the same place as joe.......:)
also possible to do it on excel and then import it into mysql.
1 step: import cities coordinates into mysql database
2 step: import country coordinates into mysql database
3 step: link table members/city/country with table cities/coord and with table countries/coord
4 step: make a new table members/coordinates cities/coordinates countries
5 step: make another column with random number 0 to 1
6 step make another columns with random number 0 to 1
7 step: make a calculation to generate a new location using constant R