I have an extremely simple db one table TblCountry and TblNames.
The name table has names of people who emigrated from Dover along with the country code (autoid) of TblCountry.
I have a wordpress site.
At present I have a decent png of a map of the world and just edited the totals against each country manually. but its too labour intensive.
Is it possible and how could I update the map from the DB.
so if USA went from 9 people to 10 it would be updated from the db.
Heres the query data:
Country Number of People
Within UK 12
USA 6
Australia 6
Spain 5
Germany 2
Virgin Islands 1
Singapore 1
Portugal 1
Norway 1
New Zealand 1
Greece 1
Gibraltar 1
SELECT TblCountry.Country, Count(TblNames.CountryID) AS [Number of People]FROM TblCountry LEFT JOIN TblNames ON TblCountry.ID = TblNames.CountryIDGROUP BY TblCountry.CountryHAVING (((Count(TblNames.CountryID))>0))ORDER BY Count(TblNames.CountryID) DESC;
I have attached the map so you can see.
regards in advance ExPatsfromDover.png
WordPressMicrosoft Access
Last Comment
PeterBaileyUk
8/22/2022 - Mon
Scott McDaniel (EE MVE )
At present I have a decent png of a map of the world and just edited the totals against each country manually.
You'd need to tell us more about how you did that. Does the map derive information from your database to show the values? If so, can you show how it does that?
als315
You can use free OpenStreetMaps plugin for Wordpress: http://wordpress.org/plugins/osm/
It can show markers from text file, which could be generated from Access and uploaded to your site.
PeterBaileyUk
ASKER
No The map was just an image and I edited in windows paint the numbers.
Thank you apologies for slow reply, had a hectic week.
PeterBaileyUk
ASKER
I tried installing the osm product and the google maps but when I try that i get the page that asks for ftp credentials and not sure what to put their.
I am already in the wordpress dashboard.
Wasnt sure either if i needed to post a new question.