Hmm...actually, I vastly over-simplified the above
There are a couple of things that are required:
1. Form asking for location / content to add
1. Database table of geo-codes with at least id, latitude, longitude, address and content fields
2. A way to actually get the latitude and longitude from the address (I will more than likely use the Yahoo Geocoding API for it - limited to 5,000 queries per day - Google's apparently is not fully ready yet, at least from what I have researched)
3. And finally a way to convert all the information from the database table into XML to send it to the Google Maps API and some AJAX to generate the actual map on the client side.
Anyway - I've seen that this post has attracted a fair amount of viewers so what I will do is upload the code that I'll write in order to get this working and hopefully it will help someone out (unless someone else will drop their code in first hehe).
Cheers,
Mike