Critter’s Code

This is a picture of a bridge and a city. I like bridges and cities. They make me smile.

Jan-11-2008

I need help with a php / mysql thing

For Seesmic World Project, I want to plot the video replies on a Google Map. The points will be geocoded by address off of the blog posts for example:

  • Paris, France
  • Cary, NC
  • Riverside County, California
  • Paris, France

As you can see from the list above, some posts will have the same title. Meaning when they are passed into Google Maps they will have the same Lat/Lon. When this happens, only the last point passed in will show. Basically what I need to do is take the query result and loop through it, combining the $post_content of duplicate $post_title’s into one $post_title

Did that make sense?

So, if I have

Post: Paris, France
Content: Hello, I am Steve from Paris

Post: Cary, NC
Content: Hello, I am Critter from Cary

Post: Paris, France
Content: Good Evening, I live in Paris

Would become:

Post: Paris, France
Content: Hello, I am Steve from Paris
Good Evening, I live in Paris

Post: Cary, NC
Content: Hello, I am Critter from Cary

Any suggestions or assistance would be greatly appreciated. PHP is not really my thing.

VN:F [1.7.5_995]
Rating: 0.0/10 (0 votes cast)
VN:F [1.7.5_995]
Rating: 0 (from 0 votes)
Posted under Site News
blog comments powered by Disqus