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
Virgin Islands 1
New Zealand 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
ORDER BY Count(TblNames.CountryID) DESC;
I have attached the map so you can see.
regards in advance