specific product location on Google Maps

[thunder-bird]

Hi Guys,

I am trying to create a website that will display certain products, vis SQL based the selection from the menu.  So far this works fine.  What I am after, and really haven't found any good tutorials on it, is how to list them in a google  map.  I am not looking at just location a certain business around a persons location but rather a specific product that that business cars.  An example might be a person whats to see what store near him carries a specific type of banana, so when he click on the product banana it would show up on google maps with all the businesses that carry the specific banana.  I am pretty sure that this would be SQL driven and the name, addresses, city, etc of these businesses would have to be in a database.

Any help is appreciated.

Thanks

[Nancy OShea]

You could write a script that exports SQL data to a CSV file and then import that it into a Google Map.

Import map features from a file - Computer - My Maps Help

[Nancy OShea · Accepted solution]

Here's another link to a tutorial that's more relevant to your question.

Using MySQL and PHP with Google Maps  |  Maps JavaScript API  |  Google Developers

[thunder-bird]

Thank you.  This is exactly what I was looking for.