Avatar of PeterBaileyUk
PeterBaileyUk
 asked on

update map on webpage from access db

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.CountryID
GROUP BY TblCountry.Country
HAVING (((Count(TblNames.CountryID))>0))
ORDER BY Count(TblNames.CountryID) DESC;

Open in new window


I have attached the map so you can see.
regards in advance
ExPatsfromDover.png
WordPressMicrosoft Access

Avatar of undefined
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.
Your help has saved me hundreds of hours of internet surfing.
fblack61
PeterBaileyUk

ASKER
Will the wordpress plugin allow me to map between one country and another?
ASKER CERTIFIED SOLUTION
als315

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
PeterBaileyUk

ASKER
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.
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.