[IanSpringham]

Hello everyone,

My name is Ian, I am 40 years old, from London (UK) and am currently helping develop a web solution for a non-profit "youth initiative" and have hit a bit of a stumbling block:

I am trying to connect a mySQL database of 8 organisations in the Greater London area and their locations (approx 1000) to Google Maps (although I would consider other online mapping solutions.)

Firstly the user enters the root of their postcode, which is checked against a table of roots, returning the latitude & longitude of the central area covered.

This is then queried against a table of organisations (name, group, address postcode, lat, long), returning those within a certain proximity (say 3 miles) using Pythagoras' theorem (based on the earth being pretty much 'flat' over comparatively short distances.)

There are eight different organisations involved, so both individual group results as well as all groups locally may be returned.

The problem I am having is getting the list of results piped through to the mapping solution. Getting the raw output converted to the XML for Google Maps is giving me quite a headache and I have been looking around for alternate solutions, even Yahoo! Pipes / Mashups.

Any thoughts, suggestions or links to existing solutions would be gratefully appreciated.

My site server details are as follows:

Apache version 2.2.11 (Unix)
PHP version 5.2.8
MySQL version 5.0.67-community
Architecture i686
Operating system Linux

Thanks in advance,

Ian