Categories
Acer adobe AMD AOL Apple AT&T computer CorelDraw Dell facebook Firefox Friendster gadget Google hacker Hewlett-Packard IBM intel Internet iPhone iPod Java Linux Microsoft Microsoft Office Microsoft Windows Mozilla Network photoshop programmer programming PS 3 Robot Software The characters in computer science Thunderbird Tips & Tricks Twitter UNIX virus - worm Windows Windows 7 Wireless Xbox Yahoo
WP Cumulus Flash tag cloud by Roy Tanck and Luke Morton requires Flash Player 9 or better.
Good Afternoon!!! camptonappraisal.com is one of the most outstanding resourceful websites of its kind. I take advantage of reading it every day. camptonappraisal.com rocks!
'; // Get tags $tags = wp_get_post_tags($post->ID); $tagsarray = array(); foreach ($tags as $tag) { $tagsarray[] = $tag->term_id; } $tagslist = implode(',', $tagsarray); // Do the query $q = "SELECT p.*, count(tr.object_id) as count FROM $wpdb->term_taxonomy AS tt, $wpdb->term_relationships AS tr, $wpdb->posts AS p WHERE tt.taxonomy ='post_tag' AND tt.term_taxonomy_id = tr.term_taxonomy_id AND tr.object_id = p.ID AND tt.term_id IN ($tagslist) AND p.ID != $post->ID AND p.post_status = 'publish' AND p.post_date_gmt < NOW() GROUP BY tr.object_id ORDER BY count DESC, p.post_date_gmt DESC LIMIT $limit;"; $related = $wpdb->get_results($q); if ( $related ) { foreach($related as $r) { $retval .= '- '
.wptexturize($r->post_title).'
';
}
} else {
$retval .= '
- No related posts found
';
}
$retval .= '
'; return $retval; } return; } add_shortcode('related_posts', 'related_posts_shortcode');