I know, I hear what you are saying! I apologize for the lack of updates. I will have the google video map linked up properly in a few days. And more videos!!!!!!

I’ve been pretty swamped on a couple of other projects (one of them being SeesmicAIR). Once I get my scripts here finished for the google maps mashup. I will get back to soliciting for replies and adding them as they come in

I have the following query:

SELECT SQL_CACHE wpblog_posts.post_title, post_content
FROM wpblog_posts
INNER JOIN wpblog_term_relationships ON wpblog_posts.id = wpblog_term_relationships.object_id
WHERE wpblog_term_relationships.term_taxonomy_id =4
GROUP BY wpblog_posts.post_title
HAVING count( wpblog_posts.post_title ) >1

Which, currently, returns 2 records:

But it should return 4 records.. the dupes... any suggestions?

If any of you out there have a bit of experience with php (any experience is more than mine), could you leave a note in the comments.

Basically what I am doing is this:

To plot these posts on Google Maps,  I am using $post_title and $post_content. I can pull those out of the database fine. The problem arises when I have two posts with the same title. When that happens Google Maps (because the lat/lons are the same) is only displaying one of the duplicates.

I need to loop through the query results, find duplicates, and combine the content so that there is only one entry per location.

Help.

(more…)

(more…)

(more…)

Coming soon…..

(more…)

(more…)