Anyone good with Google Maps?

[Butters]

Got an idea that I'm trying to put into use using Google Maps API.

Basically, a postcode is stored in a MySQL database which appears on a webapge. Next to this returned result is a 'map' button. What I want this to do is look at the entry in the returned result and paste it into the google search map bit thingy.

You can search by postcode so this is good, just need to work out how to pick up the result and enter it without manually copying and pasting.

 

[SourChipmunk]

The hyperlink you need is:

http://maps.google.co.uk/maps?f=q&hl=en&geocode=&q=[color=yellow]{postcode}[/color]

Where {postcode} should self populate with a SQL query of your Postcode field. I'm not familiar enough with SQL to know how to do that, though.

 

[Butters]

Thanks, thats great. The rest is easy, i just pass my result variable to the HTML which happens to be $postcode!

 

[Sarduk]

Why not do something even smarter, and look at using the Google Maps API to integrate your own version of the map in your website?

 

[Butters]

Yeah, I was looking at that, but I'm more than happy with the way its currently working.

Thanks though